What Are Stored-procedures? And What Are The Advantages Of Using Them

1.	What Are Stored-procedures? And What Are The Advantages Of Using Them.
Answer» STORED PROCEDURES are database objects that perform a user defined operation. A stored PROCEDURE can have a set of compound SQL statements. A stored procedure executes the SQL COMMANDS and returns the result to the client. Stored procedures are used to REDUCE network traffic. Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

What Are Stored-procedures? And What Are The Advantages Of Using Them.

Answer»

STORED PROCEDURES are database objects that perform a user defined operation. A stored PROCEDURE can have a set of compound SQL statements. A stored procedure executes the SQL COMMANDS and returns the result to the client. Stored procedures are used to REDUCE network traffic.

Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

Discussion

No Comment Found

Related InterviewSolutions

What Is Meant By Proactive, Retroactive And Simultaneous Update?
What Are Cursors Give Different Types Of Cursors.
What Are Stand-alone Procedures?
What Is Authorization And Integrity Manager?
What Is File Manager?
What Is Transaction Manager?
What Is Buffer Manager?
What Is Storage Manager?
Does Pl/sql Support "overloading"? Explain
What Are Stored-procedures? And What Are The Advantages Of Using Them.