Extended_SQL

Procedural SQL

• Procedural languages are designed to extend 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.
• Examples:
  • PL/SQL is a proprietary procedural language used by Oracle
  • PL/pgSQL is a procedural language used by PostgreSQL
  • TSQL (Transact-SQL) is a proprietary procedural language used by Microsoft in SQL Server.