I need the differences bettwen a FUNCTION, PROCEDURE and PACKAGE in Oracle. Which one is better to use in most of the times ? Thank you.
asked Jan 05, 2010 at 11:41 AM in Default
Functions return a value, procedures don't, otherwise they're identical.
A Package is a container that may have many functions and procedures within it. It provides useful capabilities such as scoping, interface definition and modular development.
It's generally advisable to put your procedures and functions into packages with well designed interfaces.
answered Jan 05, 2010 at 11:46 AM