Transact-SQL, PL/SQL, PL/pgSQL defined and compared

  • PL/SQL is a proprietary procedural language used by Oracle
  • PL/pgSQL is a proprietary procedural language used by PostgreSQL
  • TSQL is a proprietary procedural language used by Microsoft in SQL Server.

TSQL is a proprietary procedural language used by Microsoft in SQL Server . Procedural languages are designed to extend the SQL ‘s abilities while being able to integrate well with SQL .Several features such as local variables and string/data processing are added.These features make the language Turing complete.