Object-PL/SQL

Object-PL/SQL (Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database.[1] [2] The additional features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-oriented database paradigm.[3]

Although PL/SQL's general syntax formerly used to resemble that of Ada or Pascal, there were many improvements that mainly include the Java embedding code[4] and the object-oriented syntax[5] inside the SQL.

The mixing and embedding of triggers and stored procedures was one of the breakthrough points up to support the use of PL/SQL in a OO paradigm.[6] The inclusion in the SQL syntax of statements such as [class].[object], and the implementation of the object type[7] (like any OO language), completed the minimum requisites to a mapping approach in an extended SQL language without use of specific mapping software.[8]

  1. ^ Lassan, Alan R.; Due, Jacob Steen (13 June 2000). "Experiences with Object Oriented Development in PL/SQL" (PDF). The danish National Center for IT Research. Archived from the original (PDF) on 24 December 2010. Retrieved 15 April 2012.
  2. ^ Centre For; Allan R. Lassen; Jacob Steen Due (2000). "Experiences with Object Oriented Development in PL/SQL". CiteSeerX 10.1.1.38.5122. {{cite journal}}: Cite journal requires |journal= (help)
  3. ^ Cunningham, Lewis. "PL/SQL Features by Release". Burleson Consulting. Retrieved 15 April 2012.
  4. ^ "When Should you use Java Stored Procedures with an Oracle Database, what are the Drawbacks?". Stack Overflow. Retrieved 15 April 2012.
  5. ^ "Oracle's Object-Oriented Features". etutorial.org. Retrieved 16 April 2012.
  6. ^ Benett, 2002:144
  7. ^ Cite error: The named reference TOP10 was invoked but never defined (see the help page).
  8. ^ Bales, 2007:107-209