| |
GeekInterview.com > Interview Questions > Oracle > Basics
| Print | |
Question: What is the different between Stand Alone Procedure and Package?
|
| September 09, 2007 22:40:29 |
#1 |
| prasads_delight1 |
Member Since: August 2007 Total Comments: 6 |
RE: What is the different between Stand Alone Procedur...
|
Procedure is an important concept in PL/SQL. The sophisticated business rules and application logics are stored in Procedures.
The Packages are the collection of procedures, fuctions, variables and SQL command statements The packages allow multiple procedures to use same variable and coursors. The collection of procedures can be execute as per the sequence generated in the logic for package construction.
Important is to execute a procedure with in a package first we must list the package name, followed by the procedure name. |
| |
Back To Question | |
