PL/SQL

PLSQLMetatranz StepSqlitePL/SQL (Oracle)
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.wikipedia
110 Related Articles

Oracle Corporation

OracleOracle Technology NetworkOracle Corp.
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

IBM Db2 Family

DB2IBM DB2pureQuery
PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since version 7), Times Ten in-memory database (since version 11.2.1), and IBM DB 2 (since version 9.7). PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), MariaDB includes a PL/SQL compatibility parser,and IBM DB2 includes SQL Procedural Language,
These include support for the most commonly used SQL syntax, PL/SQL syntax, scripting syntax, and data types from Oracle Database.

SQL

Structured Query LanguageSQL databaseSQL Databases
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. Oracle's Berkeley DB 11g R2 release added support for SQL based on the popular SQLite API by including a version of SQLite in Berkeley DB.

Exception handling

exceptionexceptionserror handling
It can handle exceptions (run-time errors).
This includes ActionScript, Ada, BlitzMax, C++, C#, COBOL, D, ECMAScript, Eiffel, Java, ML, Next Generation Shell, Object Pascal (e.g. Delphi, Free Pascal, and the like), PowerBuilder, Objective-C, OCaml, PHP (as of version 5), PL/I, PL/SQL, Prolog, Python, REALbasic, Ruby, Scala, Seed7, Smalltalk, Tcl, Visual Prolog and most .NET languages.

Oracle Call Interface

OCIOracle Call Interface (OCI)Oracle Oci8
A block can be submitted to an interactive tool (such as SQL*Plus) or embedded within an Oracle Precompiler or OCI program.
OCI offers a procedural API for not only performing certain database administration tasks (such as system startup and shutdown), but also for using PL/SQL or SQL to query, access, and manipulate data.

SQL/PSM

Persistent Stored Modules
It implements the ISO SQL/PSM standard.
SQL/PSM is derived, seemingly directly, from Oracle's PL/SQL.

Object-PL/SQL

object-orientation
Implementations from version 8 of Oracle Database on wards have included features associated with object-orientation.
The mixing and embedding of triggers and stored procedures was one of the breakthrough points up to support the use of PL/SQL in a OO paradigm.

Database trigger

triggerstriggerprocedural triggers
A database trigger is like a stored procedure that Oracle Database invokes automatically whenever a specified event occurs.
In addition to triggers that fire (and execute PL/SQL code) when data is modified, Oracle 10g supports triggers that fire when schema-level objects (that is, tables) are modified and when user logon or logoff events occur.

TimesTen

Oracle TimesTenTimes Ten in-memory databaseTimesTen in-memory database
PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since version 7), Times Ten in-memory database (since version 11.2.1), and IBM DB 2 (since version 9.7).
After the acquisition, Neimat remained as the director of TimesTen development at Oracle, adding many Oracle database features to the product such as support for PL/SQL and integration with Oracle SQL Developer and Oracle Enterprise Manager.

Stored procedure

stored proceduresproceduresdatabase procedures
The standalone or package procedures, stored in the database, are referred to as "stored procedures".

Null (SQL)

NULL NULLs
If a variable is not initialized then it defaults to NULL value.
The procedural part of Oracle's PL/SQL supports BOOLEAN however variables; these can also be assigned NULL and the value is considered the same as UNKNOWN.

PL/pgSQL

PL/pgSQL (PostgreSQL)
PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), MariaDB includes a PL/SQL compatibility parser,and IBM DB2 includes SQL Procedural Language,
It closely resembles Oracle's PL/SQL language.

Data manipulation language

DMLData Manipulation Language (DML)manipulation
While programmers can readily embed Data Manipulation Language (DML) statements directly into PL/SQL code using straightforward SQL statements, Data Definition Language (DDL) requires more complex "Dynamic SQL" statements in the PL/SQL code.
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.

PostgreSQL

PostgresPgSQLPgAdmin
PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), MariaDB includes a PL/SQL compatibility parser,and IBM DB2 includes SQL Procedural Language,

Oracle Database

OracleOracle RDBMSOracle 10g
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

Berkeley DB

BerkeleyDBOracle BerkeleyDBBDB
Oracle's Berkeley DB 11g R2 release added support for SQL based on the popular SQLite API by including a version of SQLite in Berkeley DB.
There is third party support for PL/SQL in Berkeley DB via a commercial product named Metatranz StepSqlite.

Transact-SQL

T-SQLTransact-SQL (T-SQL)TSQL
For example, Sybase ASE and Microsoft SQL Server have Transact-SQL,

Ada (programming language)

AdaAda programming languageAda 83
The designers of PL/SQL modeled its syntax on that of Ada.

SQL PL

In DB2 version 9.7 IBM also added a PL/SQL front-end to this infrastructure (called "SQL Unified Runtime Engine"), meaning that procedural SQL using either the ISO standard or Oracle's syntax compile to bytecode running on the same engine in DB2.

Procedural programming

proceduralprocedural languageprocedural code
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

Programming language

programming languageslanguagedialect
PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

Variable (computer science)

variablevariablesscalar
It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers.

Array data type

arrayarraysmulti-dimensional array
Arrays are supported involving the use of PL/SQL collections.

Conditional (computer programming)

conditionalif-then-elseconditional statement
PL/SQL includes procedural language elements such as conditions and loops. The main feature of SQL (non-procedural) is also a drawback of SQL: one cannot use control statements (decision-making or iterative control) if only SQL is to be used.

For loop

FORfor-loop loop
The main feature of SQL (non-procedural) is also a drawback of SQL: one cannot use control statements (decision-making or iterative control) if only SQL is to be used.