Saved Bookmarks
| 1. |
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. 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. |
|