Tuesday, May 22, 2012

Creating Custom Functions in Oracle

November 5, 2009 by · Leave a Comment 

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