What Are Stand-alone Procedures?

1.	What Are Stand-alone Procedures?
Answer» Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is ONE written in a SQLForms application. These types of procedures are not AVAILABLE for reference from other Oracle TOOLS. Another limitation of stand-alone procedures is that they are compiled at RUN time, which SLOWS execution. Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQLForms application. These types of procedures are not available for reference from other Oracle tools. Another limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

Answer»

Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is ONE written in a SQL*Forms application. These types of procedures are not AVAILABLE for reference from other Oracle TOOLS. Another limitation of stand-alone procedures is that they are compiled at RUN time, which SLOWS execution.

Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These types of procedures are not available for reference from other Oracle tools. Another limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

Discussion

No Comment Found

Related InterviewSolutions

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?