Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference difference between procedure and
packages
- 2 Answers
- 10543 Views
- 3i Infotech, Oracle, I also Faced
- E-Mail Answers
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 column of the user triggers data dictionary view displays the database event that will fire the trigger?
what are all the different types of indexes? : Sql dba
What are triggers in sql?
describe transaction-safe table types in mysql : sql dba
how does a local variable is defined using t-sql? : Transact sql
How do I find duplicates in two columns?
Can we debug stored procedure?
Mention what pl/sql package consists of?
Can we join two tables without common column?
Differentiate between % rowtype and type record.
Explain raise_application_error.
What is sql in oracle?
What is cost in sql execution plan?
What is normalisation in sql?
How do you use collections in procedure to return the resultset?
