Based the task performed by oracle functions we can classify oracle functions in the following.
A)Single-Row Functions: Single row functions return just one row for every row of a queried table or view. A detail explanation of single row function is found in
B)Aggregate Functions: Aggregate function returns a single row based on a set of rows. A common use of aggregate function is with the GROUP BY clause in a SELECT statement. A detail explanation of aggregate function is found in
C)Analytic Functions: Analytic functions compute an aggregate value based on a group of rows. The difference of analytic function from aggregate functions in that they return multiple rows for each group. A detail explanation of analytic function is found in
D)Object Reference Functions: Object reference functions manipulate REF values, which are references to objects of specified object types. A detail explanation of object reference function is found in
E)Model Functions: Model functions can be used only in the model_clause of the SELECT statement. A details explanation of model functions are discussed in
F)User Defined Functions: