Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the difference difference between procedure and
packages

Answers were Sorted based on User's Feedback



what is the difference difference between procedure and packages..

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

Is This Answer Correct ?    7 Yes 1 No

what is the difference difference between procedure and packages..

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

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is composite primary key in sql?

0 Answers  


how u can find the n row from a table?

19 Answers   Tech Mahindra,


What are sql constraints?

0 Answers  


what is table? : Sql dba

0 Answers  


Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  






what is data integrity

3 Answers   Fidelity, TCS,


what is an index? : Sql dba

0 Answers  


What is the difference between rollback and rollback to statements?

0 Answers  


how to enter characters as hex numbers? : Sql dba

0 Answers  


What does rownum mean in sql?

0 Answers  


How many tables can a sql database have?

0 Answers  


What is compute?

0 Answers  






Categories