Answer / kanchan kumari

procedure is named pl/sql block which is used by
programmer to perform any task these type of block exist in
database physically.

package is also named pl/sql block which is associated
with pl/sql variable, view, sub programs.
package can't be invoked
in other word we can say that package can contain more than
one procedure, function etc.but procedure can't

Answer / rajesh venati

A Procedure is a Named Pl/Sql program. Procedures are used
for to perform a particular task. Overloading concept is not
allowed in standard alone procedures.

Then go for Packages, package is grouping the collection of
database objects like procedures, functions, type, variable,
cursors and exception etc... Here overloading concept is
valid, we can define same name for database objects with
different type of parameters or data types.....

I believe this is useful.................

Does pdo prevent sql injection?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

what is the difference between join and union? : Sql dba

0 Answers  

---

What are local and global Indexes and where they are useful.

0 Answers  

---

---

Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---

What packages are available to pl/sql developers?

0 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

What happens when a trigger is associated to a view?

0 Answers  

---

How do we tune the code?

2 Answers  

---

How can you select unique records from a table?

0 Answers  

---