top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between SQL, PL-SQL and T-SQL?

+2 votes
421 views
What is the difference between SQL, PL-SQL and T-SQL?
posted Jun 23, 2015 by Manikandan J

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
SQL is a query language to operate on sets.
It is more or less standardized, and used by almost all relational database management systems: SQL Server, Oracle, 
MySQL, PostgreSQL, DB2, Informix, etc.
PL/SQL is a proprietary procedural language used by Oracle
PL/pgSQL is a procedural language used by PostgreSQL
TSQL is a proprietary procedural language used by Microsoft in SQL Server. 



SQL: a language for talking to the database. It lets you select data, mutable and create database objects (like tables, 
views, etc.), change database settings.
PL-SQL: a procedural programming language (with embedded SQL)
T-SQL: (procedural) extensions for SQL used by SQL Serve 
answer Jun 24, 2015 by Shivaranjini
...