Explain the characteristics of function object in Oracle. A function object in Oracle is used to perform a set of repetitive tasks. A function can be either user defined or in built. A function object can take three parameters: - IN, OUT and INOUT. Depending on the parameter passed to the function, it returns a value.
Explain the characteristics of function object in Oracle. - A function can allow one or more or no parameter.
- A function must have explicit return statement.
- The data type of the return value must be declared in the function’s header.