What are procedure,functions,packages in pl/sql?
Posted by admin on Dec 05 2006
A stored procedure, function, or package is a PL/SQL program unit that:
- Has a name.
- Can take parameters, and can return values.
- Is stored in the data dictionary.
- Can be called by many users.
procedures return no value functions always return single value to the caller
Functions can be called from SQL, procedure cannot
Functions are considered expressions, procedure are not
Leave a Comment