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
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Mention what pl/sql package consists of?
What is sql injection owasp?
What is trigger and types?
what is a table in a database ? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
What are the sql aggregate functions?
How to raise user-defined exception with custom sqlerrm ?
what are the 'mysql' command line options? : Sql dba
Can you have a foreign key without a primary key?
Which are the different case manipulation functions in sql?
When is the update_statistics command used?
What is difference between primary and secondary key?
What is sql basics?
In a distributed database system, can we execute two queries simultaneously?