1.

PL/SQL vs T/SQL

Answer»

PL/SQL is an extension for SQL and Oracle. It enhances the capabilities of SQL. Therefore, with every release of the Oracle Database, the feature and functionalities of PL/SQL is enhanced.

It is available in Oracle Database since version 6. HOWEVER, PL/SQL is also available in TimesTen in-memory database since version 11.2.1 and IBM DB2 since version 9.7.

TL/SQL is Transact Structure Query language. T-SQL EXPANDS on the SQL standard to add procedural programming, local variables, etc. It is Microsoft's and Sybase's proprietary extension to the SQL.

The following are the differences:

Basis
PL/SQL
T/SQL
Efficiency
It is more POWERFUL than T/SQL.
T/SQL is less powerful than PL/SQL.
Relation with SQL
PL/SQL is an extension for SQL and Oracle. It enhances the capabilities of SQL.
T-SQL expands on the SQL standard to add procedural programming, local variables, etc.
Full Form
PL SQL is Procedural Language STRUCTURAL Query Language.
TL SQL is Transact Structure Query language.
Compatibility
PL-SQL works best with Oracle database Server.
T-SQL works best with Microsoft SQL Server
Easier/ Complex
PL/SQL is considered complex to learn than
T/SQL
It is easier to learn and work with T/SQL.
Developer
It is DEVELOPED and owned by Oracle.
T/SQL is Microsoft's and Sybase's proprietary extension to the SQL.


Discussion

No Comment Found

Related InterviewSolutions