Technical Discussion :: Oracle PLSQL
Home > Freshers > Technical Interview Questions > Oracle PLSQL
112. What is a Stored Procedure? State its advantage.
Answer:
A stored procedure is a set of per-compiled SQL commands (query statements), which are stored in the server. It is faster then the loose SQL statements processed on client, as it is per-compiled. It can execute more then one SQL commands once as they are bundled in a single entity. We can use control statements within the stored procedure, which will allow us to repeat some SQL command. It can send return values depending upon the result. Stored procedures are used to reduce network traffic.
Asked In :: Virtusa
A stored procedure is a set of per-compiled SQL commands (query statements), which are stored in the server. It is faster then the loose SQL statements processed on client, as it is per-compiled. It can execute more then one SQL commands once as they are bundled in a single entity. We can use control statements within the stored procedure, which will allow us to repeat some SQL command. It can send return values depending upon the result. Stored procedures are used to reduce network traffic.