Content deleted Content added
mNo edit summary |
|||
Line 13:
''Database objects'' are concepts that refer to [[Relational model|relational]] or even sequencial database and persist being valid in new models. ''Tables'', ''triggers'', ''columns'', ''indexes'' are examples of database objects<ref name="TOP10">{{cite web|url=http://www.codeproject.com/Articles/43629/Top-10-steps-to-optimize-data-access-in-SQL-Server|title=Optimize Database Files and Apply Partitioning|author=Shubho, Al-Farooque|date=8 November 2009|publisher=The Code Project|accessdate=19 April 2012}}</ref>, nothing to see with ''classes objects'', witch are present too in O-PL/SQL with the same meaning of the notion of [[Java (programming language)|Java]] objects, specifically an element of a set that has its existence beginning from an instantiation of a class.
== The PL/SQL ==
{{Main|PL/SQL}}
'''''PL/SQL''''' is the extended SQL language used by [[Oracle Database]].
Line 19:
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, 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 ==
| |||