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 delimiter sql?
what is a cursor? : Sql dba
What is bulk collect in pl sql?
What is sql server and ase?
What is primary and foreign key?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Which sql statement is used to delete data from a database?
What is the largest value that can be stored in a byte data field?
What is serial sql?
What is #table in sql?
what is the bond code in materialized view?
What is sql rowcount?
What is acid property in a database?
Define commit, rollback and savepoint?
How do I run a sql query?
