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 is the difference between a query and a report?
How to add new employee details in an employee_details table with the following details
What are the advantages of indexing?
What is coalesce in sql?
What is the difference between microsoft sql and mysql?
What is a join query?
Does mysql_real_escape_string prevent sql injection?
Is pl sql better than sql?
what are the types of join and explain each? : Sql dba
Why is sql*loader direct path so fast?
how to get help information from the server? : Sql dba
How can we find duplicate records in a table?
What are triggers and its types?
What is the cause of mutating table error and how can we solve it?
What operating systems are supported by oracle sql developer?