Creating Custom Functions in Oracle Here it is a simple procedure to create and call a custom function in Oracle. A custom function is a simple PL/SQL subprogram that is used to calculate a value. It creation syntax is almost same as of procedure except it has a RETURN clause that is used to return the computed value.
Syntax of creating a custom function:
CREATE [OR REPLACE] FUNCTION function_name [...
by Nauman at November 5th, 2009 at 12:11 am