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 sql in mysql? : Sql dba
What are sql functions? Describe the different types of sql functions?
Difference between table function and pipelined function?
What is not equal in sql?
Do prepared statements prevent sql injection?
Does sql use python?
What are the different schemas objects that can be created using pl/sql?
What is crud diagram?
what are the differences between char and nchar? : Sql dba
What is the purpose of design view?
What is dense_rank?
What are the different ways to optimize a sql query?
What is the use of function in sql?
What is a database event trigger?
What is the difference between delete and truncate statement in sql?