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

What is query optimization in sql?

0 Answers  

---

What is a parameter query?

0 Answers  

---

Can we update views in sql?

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---

Does sql support programming?

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---

What is sql*plus?

0 Answers  

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

What is rtm stands for?

0 Answers  

---