Saved Bookmarks
| 1. |
Explain The Difference Between A Function, Procedure And Package? |
|
Answer» A FUNCTION and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a SINGLE task. While a procedure does not have to return any VALUES to the CALLING application, a function will return a single value. A package on the other hand is a collection of functions and PROCEDURES that are grouped together based on their commonality to a business function or application. A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any values to the calling application, a function will return a single value. A package on the other hand is a collection of functions and procedures that are grouped together based on their commonality to a business function or application. |
|