what is the difference difference between procedure and
Answers were Sorted based on User's Feedback
Answer / kanchan kumari
procedure is named pl/sql block which is used by
programmer to perform any task these type of block exist in
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|
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|
What is composite primary key in sql?
how u can find the n row from a table?
What are sql constraints?
what is table? : Sql dba
Can a view be updated/inserted/deleted?If Yes under what conditions?
what is data integrity
what is an index? : Sql dba
What is the difference between rollback and rollback to statements?
how to enter characters as hex numbers? : Sql dba
What does rownum mean in sql?
How many tables can a sql database have?
What is compute?