[Home]History of PL SQL

HomePage | Recent Changes | Preferences

Revision 3 . . (edit) November 2, 2001 3:58 am by Justfred
Revision 2 . . November 1, 2001 11:38 pm by Damian Yerrick [why declarative SQL can't loop; PL/pgSQL emulates Oracle PL/SQL; Java is an adjective]
Revision 1 . . October 31, 2001 3:23 pm by Alan Millar [Moved from PL/SQL]
  

Difference (from prior major revision) (minor diff, author diff)

Changed: 1,2c1,4
PL/SQL - Procedural Language/Structured Query Language (PL/SQL) is Oracle Corporation's propretary extension to the SQL language.
Since SQL is a declarative language some constructs, such as loops, are impossible in it. PL/SQL is a Turing-complete procedural language which fills in these gaps and allows Oracle database developers to interface with the underlying relational database. PL/SQL functions can be called from SQL code.
PL/SQL - Procedural Language/Structured Query Language (PL/SQL) is Oracle Corporation's propretary extension to the SQL language.
Since SQL is a declarative language, and (unlike some functional programming languages such as Scheme) the standard does not require implementations to convert tail calls to jumps or readily provide "first row" and "rest of table" accessors, SQL cannot easily perform some constructs such as loops.
PL/SQL is a Turing-complete procedural language which fills in these gaps and allows Oracle database developers to interface with the underlying relational database in an imperative manner.
SQL queries call PL/SQL functions through constructions such as triggers.

Changed: 4c6,8
PL/SQL is analogous to the embedded procedural languages for other relational databases. Sybase? and its derivative [Microsoft SQL Server]? have Transact-SQL, PostgreSQL has Pg/SQL, and Oracle also allows Java to be used.
PL/SQL is analogous to the embedded procedural languages for other relational databases.
Sybase? and its derivative [Microsoft SQL Server]? have Transact-SQL, PostgreSQL has PL/pgSQL (which tries to emulate PL/SQL to an extent), and Oracle can also use methods written in the Java programming language.
Aside from some proprietary functions (notably Oracle's UTL_FILE package) PL/SQL code is nearly identical to Transact-SQL; conversions are simple if no proprietary features are used.

HomePage | Recent Changes | Preferences
Search: