Functions

Oracle functions serve the purpose of manipulating data items and returning a result functions are also capable of accepting user-supplied variables or constants and operating on them. Functions can be classified as follows.
Group Functions/Aggregate Functions:-
      Functions that act on a set of values are called as group functions. A grouped functions returns single result row for a group of queried rows.
Scalar Functions/Single Row Functions:-
      Functions that act on only one value at a time are called as scalar functions. Single row functions can be further grouped together by the data type of their argument and return values. Functions can be classified corresponding to different data type as :

For
Online Classes

Contact Us: +919885348743