Answer Posted / charumathi
Store Procedure is named PL-SQL block stored in oracle
server when loaded into memory while execution.
A stored procedure is -a named group of SQL statements
-that have been previously created
and stored in the server database.
-Stored procedures accept input
parameters so that a single procedure can be used over the
network by several clients using different input
data.
-Stored procedures reduce network
traffic and improve performance. Additionally, stored
procedures can be used to help ensure the integrity of the
database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what is a database?
What is the use of triggers?
Can we call stored procedure in function?
Does postgresql run on the cloud?
How delete all data from all tables in sql?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is input buffer in sql*plus?
Is sqlexception checked or unchecked?
Explain what is table in a database?
What is field delimiter?
Explain two easy sql optimizations.
What is an inconsistent dependency?
What is the difference between sum and count in sql?
What is constant in pl sql?
Show code of a cursor for loop.
