The Oracle database supports dozens of functions. The majority of the functions are "scalar", or column, functions as opposed to "aggregate", or group
functions such as
count. In this topic I'll introduce you to a couple of useful scalar functions.
To learn how to use the functions in Oracle, follow these steps:
Employeestable. First, we will issue an SQL*Plus statement to limit the column size on output for readability:
||) for department ID = 60:
substr(substring) function to display the substring beginning in position 1 of the first name for a length of 1.