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
how to start mysql server? : Sql dba
What is record variable?
What problem one might face while writing log information to a data-base table in pl/sql?
what are the nonstandard string types? : Sql dba
How many functions are there in sql?
Can we use two order by clause in query?
what is the difference between truncate and drop statements? : Sql dba
what is collation? : Sql dba
what are null values? : Sql dba
What are the different types of joins in sql?
What is pl sql commands?
What is mutating error in pl sql?
what is the functionality of the function htmlentities? : Sql dba
what is union? : Sql dba
What is the least restrictive isolation level? : Transact sql
