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.

Why do we use view in sql?

909

---

Write the command to remove all players named sachin from the players table.

1121

---

What is the difference between inner join and outer join?

929

---

what are the advantages a stored procedure? : Sql dba

924

---

what are the differences among rownum, rank and dense_rank? : Sql dba

981

---

What are the two virtual tables available at the time of database trigger execution?

1157

---

Can we commit in trigger?

921

---

what are the nonstandard string types? : Sql dba

1083

---

What is mutating table error?

1116

---

What is graph sql?

936

---

how to concatenate two character strings? : Sql dba

1030

---

How to get unique records from a table?

897

---

How do you go back in sql?

940

---

What's the procedure?

865

---

how many ways we can we find the current date using mysql? : Sql dba

1035

---