Yaseen

• May 12th, 2007

 

SQL (Structures Query Language)
PL/SQL (Procedure Language / SQL) is the Oracle's version with lots of additional proprietary functions.
T-SQL : Transact-SQL is Microsoft's proprietary version of SQL.

psingla

 Profile Answers by psingla Questions by psingla

• Apr 28th, 2010

 

PL/SQL is procedural language.
It is built upon sql with extra added functionalities.
It is used by ORACLE.
robust and consistent
exception handling is great
the concept of package is great
disallow bad coding
less flexible in case of settings so disallow bad coding

T-SQL(transaction-SQL) is again a procedural language but its proprietry of microsoft.
It is built upon sql with extra added functionalities.
used in SQL  server.
not robust as pl/sql
Exception handling is not good
No concept of packages
its very flexible with respect to settings