Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / roopesh kumar
The stored procedures are compiled pl/sql code block that
are stored in oracle's data dictonary as p-code. When we
have to use a perticular code block many times then we
should use procedure, function etc.
The use of procedure save time of execution of a block &
remove the need to write the code of a block every time.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Which software is used for pl sql programming?
what are the different tables present in mysql? : Sql dba
What is user defined functions?
Enlist the advantages of sql.
What are predefined functions in sql?
How exception handling is done in advance pl/sql?
Why is there a need for sqlcode and sqlerrm variables?
What is trigger and how to use it in sql?
Is it possible to sort a column using a column alias?
What is embedded sql with example?
How is pl sql different from sql?
What is rownum and rowid?
Is sql a dbms?
What is rollback?
