SQL/PSM

Persistent Stored Modules
SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.wikipedia
36 Related Articles

SQL

Structured Query LanguageSQL databaseSQL Databases
SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

Stored procedure

stored proceduresproceduresdatabase procedures
SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.
The increasing adoption of stored procedures led to the introduction of procedural elements to the SQL language in the SQL:1999 and SQL:2003 standards in the part SQL/PSM.

SQL:1999

ANSI SQL 99ANSI-99SQL 3
Initially published in 1996 as an extension of SQL-92 (ISO/IEC 9075-4:1996, a version sometimes called PSM-96 or even SQL-92/PSM ), SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2016.

PL/SQL

PLSQLMetatranz StepSqlitePL/SQL (Oracle)
SQL/PSM is derived, seemingly directly, from Oracle's PL/SQL.
It implements the ISO SQL/PSM standard.

SQL-92

SQL92SQL 92ANSI-92
Initially published in 1996 as an extension of SQL-92 (ISO/IEC 9075-4:1996, a version sometimes called PSM-96 or even SQL-92/PSM ), SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2016.

SQL PL

IBM's SQL PL (used in DB2) and Mimer SQL's PSM were the first two products officially implementing SQL/PSM.
It is a subset of the SQL Persistent Stored Modules (SQL/PSM) language standard.

MySQL

M'''ySQLMySQL 4.1MySQL 4.x
It is commonly thought that these two languages, and perhaps also MySQL/MariaDB's procedural language, are closest to the SQL/PSM standard.

PostgreSQL

PostgresPgSQLPgAdmin
However, a PostgreSQL addon implements SQL/PSM (alongside its other procedural languages like the PL/SQL-derived plpgsql), although it is not part of the core product.

PL/pgSQL

PL/pgSQL (PostgreSQL)
Version 9 also implements some ISO SQL/PSM features, like overloading of SQL-invoked functions and procedures.

Ada (programming language)

AdaAda programming languageAda 83
Oracle developed PL/SQL and released it in 1991, basing the language on the US Department of Defense's Ada programming language.

International Organization for Standardization

ISOISO standardInternational Organisation for Standardisation
SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

Procedural programming

proceduralprocedural languageprocedural code
SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

SQL:2016

Initially published in 1996 as an extension of SQL-92 (ISO/IEC 9075-4:1996, a version sometimes called PSM-96 or even SQL-92/PSM ), SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2016.

Control flow

looploopscontrol structure
SQL/PSM standardizes syntax and semantics for control flow, exception handling (called "condition handling" in SQL/PSM), local variables, assignment of expressions to variables and parameters, and (procedural) use of cursors.

Exception handling

exceptionexceptionserror handling
SQL/PSM standardizes syntax and semantics for control flow, exception handling (called "condition handling" in SQL/PSM), local variables, assignment of expressions to variables and parameters, and (procedural) use of cursors.

Cursor (databases)

Cursorcursorsdatabase cursor
SQL/PSM standardizes syntax and semantics for control flow, exception handling (called "condition handling" in SQL/PSM), local variables, assignment of expressions to variables and parameters, and (procedural) use of cursors.

Metadata

meta datameta-datacommunications metadata
It also defines an information schema (metadata) for stored procedures.

Method (computer programming)

methodsmethodabstract method
SQL/PSM is one language in which methods for the SQL:1999 structured types can be defined.

Structured type

structured user-defined type
SQL/PSM is one language in which methods for the SQL:1999 structured types can be defined.

SQL/JRT

Java stored procedureSQL Routines and Types Using the Java Programming Language
The other is Java, via SQL/JRT.

United States Department of Defense

Department of DefenseU.S. Department of DefenseUS Department of Defense
Oracle developed PL/SQL and released it in 1991, basing the language on the US Department of Defense's Ada programming language.

Mimer SQL

IBM's SQL PL (used in DB2) and Mimer SQL's PSM were the first two products officially implementing SQL/PSM.

MariaDB

MariaDB CorporationMariaDB FoundationMariaDB 10.2+
It is commonly thought that these two languages, and perhaps also MySQL/MariaDB's procedural language, are closest to the SQL/PSM standard.

Virtuoso Universal Server

OpenLink VirtuosoVirtuosoOpenLink Virtuoso (Open Source Edition)
RDF functionality in OpenLink Virtuoso was developed entirely through SQL/PSM, combined with custom datatypes (e.g., for handling URI and Literal relation objects), sophisticated indexing, and flexible physical storage choices (column-wise or row-wise).