Jump to content

PL/SQL

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Linlasj (talk | contribs) at 22:50, 30 October 2001. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

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.


There are other embedded procedural languages for other relational databases. Microsoft SQL Server has Transact-SQL, PostgreSQL has Pg/SQL, and Oracle also allows Java to be used.



This is not a good page name. Try the "PL" link at the top... :-) --Pinkunicorn


Retrieved from "https://en.wikipedia.org/w/index.php?title=PL/SQL&oldid=274796"