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

Can we use two order by clause in query?

0 Answers  

---

How do I order by ascending in sql?

0 Answers  

---

What is clustered index in sql?

0 Answers  

---

How to execute a stored procedure?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---

Explain the methods used to protect source code of pl/sql.

0 Answers  

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

What are % type and % rowtype?

0 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

what is not null constraint? : Sql dba

0 Answers  

---