Answer / aravinda

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

Modularity, easy to design applications, information hiding,
added functionality and best performance.

we can declare global variables in packages which are valid
across application.

without invalidating the package we can modify the package body.

Answer / dhiraj

Packages are bunch of procedures and functions instead of
granting one by one procedure and function DBA can grant
packge to user.

Answer / 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

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

How many indexes can be created on a table in sql?

0 Answers  

---

What is mutating sql table?

0 Answers  

---

What is java sql connection?

0 Answers  

---

When is the update_statistics command used?

0 Answers  

---

What is a column in a table?

0 Answers  

---

What is sql performance tuning?

0 Answers  

---

what is a trigger in mysql? : Sql dba

0 Answers  

---

What is triggering circuit?

0 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---