Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference difference between procedure and
packages
- 2 Answers
- 10393 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
What is cursor and its types?
what is the difference between a local and a global temporary table? : Sql dba
Explain aggregate functions are available there in sql?
How to display Row Number with Records in Oracle SQL Plus?
What is sap sql anywhere?
Can we create a trigger on view?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How do you write an index?
How do I run a sql trace?
What are the different type of joins in sql?
What is sqlcontext?
What does plv msg allows you to do?
Can we commit in trigger?
What is a recursive join sql?
What is sql indexing?
