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.
|