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 sql in java?
What is multiple partition?
What is java sql drivermanager?
what is the difference between char_length and length? : Sql dba
What are different joins used in sql?
Can we create clustered index without primary key?
What is java sql driver?
Why we use join in sql?
What is the best free sql database?
what is an extent ? : Sql dba
What is oracle and pl sql?
What is sql resultset?
what happens if you no create privilege in a database? : Sql dba
What is serial sql?
What is the difference between sql and isql*plus?