Stored Procedure Question:
Download Questions PDF

State the different extensions for stored procedures?

Answer:

Most of the database systems have proprietary and vendor based extensions. Microsoft allows procedures to be written using Transact-SQL. Oracle calls its extension as PL/SQL. DB2 has its extension as PL/SQL. PL/pgSQL is the extension used by Postgre SQL and this allows users to have their own functional language such as pl/PHP and pl/Perl.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
Explain about the implementation of stored procedures?State about the security aspects of stored procedures?