PL / SQL ++ (object properties of PL / SQL language – comparison with OOPL languages Java and Eiffel)


In 1997, Oracle Corporation released the Oracle 8.0 version of the database and called it object-relational. The PL / SQL programming language (but also SQL) has been supplemented accordingly. This version of the database, as well as the next version 8i (with Java within the database), did not have some important object capabilities such as inheritance, method override, polymorphism. These capabilities were introduced by Oracle in 2001 in database 9i. The paper presents some object properties of Oracle PL / SQL 9 and R2 languages, but without showing the object properties of SQL language (showing work with transient objects, not persistent objects), which allows the comparison of PL / SQL languages with OOPL languages Java and Eiffel.