Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is difference between procedure and trigger?
What is the use of pl/sql table?
how many columns can be used for creating index? : Sql dba
Is null operator in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
How do I save the results of sql query in a file?
What are the two virtual tables available at the time of database trigger execution?
What are the disadvantages of file system?
What are all the different types of indexes?
In what condition is it good to disable a trigger?
Are there any features that are decommissioned in 11g that are not present in 11g?
what is normalization? : Sql dba
How do I start sql from command line?
Why do we need pl sql?
Does normalization improve performance?
