what is the difference difference between procedure and
packages
Answer Posted / 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 View All Answers
Which version of sql do I have?
Explain how to use transactions efficiently : transact sql
What are the disadvantages of file system?
What is pl sql script?
What is dml and ddl?
What is oracle sql called?
What is pl sql commands?
Explain what is a field in a database and record in a database?
How do I view a sql trace file?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Inline the values in PL/SQL, what does it mean.?
What is the process of debugging?
What jobs use sql?
Why do we need a foreign key?
how to see the create table statement of an existing table? : Sql dba