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 do I order by ascending in sql?
Explain what is a column in a table?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is sql server and ase?
What is the difference between delete and truncate statement in sql?
Can we insert data into materialized view?
What is orm in sql?
What is auto increment feature in sql?
Can we call dml statement in function?
How do you delete a table?
What is pl sql code?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Explain polymorphism in pl/sql.
How do I add a primary key to a table?
how to get a list of columns in an existing table? : Sql dba
