Answer Posted / ramakrishna

package is collection of logically related pl/sql types
,items, subprograms. packages have following advantages over
procedures and functions are

1.reduces number of acces to database.since, When you call
a packaged PL/SQL construct for the first time, the whole
package is loaded into memory. Thus, later calls to
constructs in the same package require no disk input/output
(I/O).

2.we can have overloading,public and private,encapsulation
features (like java) in package

Explain mutating table error.

1256

---

How to raise user-defined exception with custom sqlerrm ?

1177

---

How do I start pl sql?

990

---

How do I truncate a word?

1155

---

What is the trigger in sql?

1000

---

How do you modify a column in sql?

1046

---

what is blob? : Sql dba

1215

---

What is the purpose of the primary key?

1117

---

What operating systems are supported by oracle sql developer?

1010

---

What is pl sql code?

1099

---

How much does sql cost?

1063

---

what are the advantages of mysql in comparison to oracle? : Sql dba

1044

---

How many parts of a pl sql block are optional?

1213

---

How many types of index are there?

1098

---

What is compilation error in pl sql?

1021

---