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 are different types of triggers?
What is primary key and unique key?
How does cross join work in sql?
Is it possible to update views?
Does pdo prevent sql injection?
What are two statement types in sql?
Is like operator in sql case sensitive?
What is record variable?
What is blind sql injection?
Give the order of sql select?
What is mdf ldf and ndf?
how to see the create table statement of an existing table? : Sql dba
What is the difference between a primary key and a clustered index?
What is execute immediate?
What is the difference between sum and count in sql?