what is the difference difference between procedure and
packages
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
database physically.
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 pl/sql table? Why is it used?
How many disk partitions should I have?
What is the difference between alter trigger and drop trigger statements?
Sql technical questions
How are sql commands classified?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
How do rank () and dense_rank () differ?
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
What is write ahead logging in sql server?
What are database links used for?
how will be date change into string
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?