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 trigger in sql?
What are the types of variable use in pl sql?
What is a dynamic query?
Why use truncate instead of delete?
How sql query is executed?
What is trigger price?
Explain the purpose of %type and %rowtype data types with the example?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Explain exception handling in pl/sql?
How many triggers can be applied on a table?
What is cursor explain with example?
what are the differences between binary and varbinary? : Sql dba
How can a function retun more than one value in oracle with proper example?
Can we insert data in view?
What is pl sql in dbms?
