Programmatic Constructs Question:

Explain What are the advantages of having a Package?

Oracle Programmatic Constructs Interview Question
Oracle Programmatic Constructs Interview Question

Answer:

Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)


Previous QuestionNext Question
Explain What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?Explain What is difference between Procedures and Functions?