PL/SQL

Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. PL/SQL is Oracle Corporation's procedural extension language for SQL and the Oracle relational database. PL/SQL's general syntax resembles that of Ada or Pascal. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. PL/SQL is available in Oracle Database, TimesTen in-memory database, and IBM DB2. PL/SQL supports variables, conditions, loops and exceptions. Arrays are also supported, though in a somewhat unusual way, involving the use of PL/SQL collections. PL/SQL collections is a slightly advanced topic. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation.