Answer Posted / useroracle

Advantages of package:
-----------------------
A. Modularity
- Encapsulate related constructs.

B. Easier Application Design
- Code and compile specification and body separately.

C. Hiding Information
- Only the declarations in the pacakge specification
are visible and accessible to application.
- Private constructs in the package body are hidden
and inaccesible.
- All coding is hidden in the package body.

D. Added Functionality
- Persistency of variables and coursors.

E. Better Performance
- The entire package is loaded into memory when the
package is first referenced.
- There is only one copy in memory for all users.
- The dependency hierarchy is simplified.

F. Overloading
- Multiple subprograms of the same name.

What is inner join in sql?

1079

---

what are the limitations of identity column? : Transact sql

1108

---

What do you understand by pl/sql records?

1018

---

What are the most important characteristics of pl/sql?

1155

---

How many clustered indexes can you have?

974

---

Is it possible to read/write files to-and-from PL/SQL?

1101

---

How do I copy a table in sql?

988

---

Mention what is the plv (pl/vision) package offers?

1107

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

968

---

Why query optimization is needed?

923

---

how many columns can be used for creating index? : Sql dba

946

---

How many sql statements are used? Define them.

1038

---

Explain the components of sql?

1060

---

Are stored procedures faster than queries?

944

---

What is query execution plan in sql?

1186

---