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
how to concatenate two character strings? : Sql dba
Can we use rowid as primary key?
What is online transaction processing (oltp)?
Can a trigger call a stored procedure?
What is the default isolation level in sql server? : Transact sql
what is normalization? : Sql dba
What is pl sql block in dbms?
What is sql character function?
What is meant by cursor in sql?
What are types of exception?
What is pl sql in dbms?
What are sql procedures?
What is java sql package?
How can you load microsoft excel data into oracle? : aql loader
Why commit is not used in triggers?