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.................

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

What are the different operators available in sql?

0 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

What is a file delimiter?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

What are the three forms of normalization?

0 Answers  

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

What is a column in a table?

0 Answers  

---

What does count (*) do in sql?

0 Answers  

---