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.

How can we avoid duplicating records in a query?

1031

---

What are variables in pl sql?

1230

---

What is the best partition size for windows 10?

1049

---

What are the set operators in sql?

1136

---

Mention what plvcmt and plvrb does in pl/sql?

1200

---

what is query cache in mysql? : Sql dba

1080

---

What are string functions in sql?

1302

---

What is the difference between jpql and sql?

1144

---

Do foreign keys improve performance?

1068

---

what is the difference between group by and order by in sql? : Sql dba

1185

---

What is a schema sql?

1224

---

Can primary key be changed?

952

---

Can we call procedure in select statement?

1110

---

what is 'mysqladmin' in mysql? : Sql dba

1073

---

Give the order of sql select?

1185

---