Illustrates the various extensions for stored procedures

Question

Illustrates the various extensions for stored procedures?

Answer 1

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