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
Why we use stored procedure instead of query?
Difference between global and parameter variables?
Write a sql select query that only returns each name only once from a table?
Is merge a dml statement?
How many types of relationship are there?
Explain the advantages and disadvantages of stored procedure?
Why do we use partitions in sql?
Explain exception handling in pl/sql?
What is an inconsistent dependency?
Is it possible to update views?
What are sql constraints?
define sql update statement ? : Sql dba
How many sql databases can you have on one server?
What are different functions in sql?
What is the file extension for sql database?
