Object-PL/SQL: Difference between revisions

Revision as of 21:36, 20 April 2012

Revision as of 21:38, 20 April 2012

Line 15:

== The PL/SQL ==

{{Main|PL/SQL}}

'''''PL/SQL''''' is the extended SQL language used by [[Oracle Database]].

PL/SQL is available in Oracle Database (since version 7), [[TimesTen|TimesTen in-memory database]] (since version 11.2.1), and [[IBM DB2]] (since version 9.7).<ref name="IBM">{{cite web|url=http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/index.html|title=DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows|publisher=IBM|accessdate=20 April 2012}}</ref>

O-PL/SQL allows the definition of classes and instantiating these as objects,
th
us creating user-defined datatypes as and writing constructors, beyond using Java in stored procedures and triggers.

== Examples of uses of syntax of O-PL/SQL ==