Home > DeveloperSection > Interviews > State the different extensions for stored procedures?

Posted on    January-21-2015 10:46 PM

 MSSQL Server SQL Server 
Ratings:
 1 Answer(s)
  587  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Points:400
Posted on    January-21-2015 11:46 PM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick