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 the difference between primary key and unique key? : Sql dba
What is the function that is used to transfer a pl/sql table log to a database table?
What is the least restrictive isolation level? : Transact sql
What is a unique constraint?
Why schema is used in sql?
How to call a javascript function from pl sql?
What is difference between inner join and cross join?
What is the difference between left join and right join?
Explain the steps needed to create the scheduled job?
what are the disadvantages of mysql? : Sql dba
Can we insert data into view?
What is cursor and why it is required?
What is constant in pl sql?
What is the difference between explicit and implicit cursors in oracle?
What are properties of the transaction?
