|
PLSQL
PL/SQL (Procedural Language for SQL) is Oracle Corporation's Procedural programming, procedural programming language, extension for SQL and the Oracle Database, Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored PL/SQL procedures/functions/packages/triggers since version 7), TimesTen, Times Ten in-memory database (since version 11.2.1), and IBM Db2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as Conditional (programming), conditions and program loop, loops. It allows declaration of constants and variable (programming), variables, procedures and functions, types and variables of those types, and triggers. It can handle exception handling, exceptions (run-time errors). Array data type, Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Object-PL/SQL
Object-PL/SQL (Object-oriented programming, Object-Procedural Language/Structured Query Language or simply O-PL/SQL) is a methodology of using the Oracle Corporation's Procedural programming, procedural extension programming language, language for SQL and the Oracle Database, Oracle relational database. The additional features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-oriented database paradigm. Although PL/SQL's general Syntax (programming languages), syntax formerly used to resemble that of Ada (programming language), Ada or Pascal (programming language), Pascal, there were many improvements that mainly include the ''Java embedding code'' and the ''object-oriented syntax'' inside the SQL. The mixing and embedding of Database trigger, triggers and stored procedures was one of the breakthrough points up to support the use of PL/SQL in a ''OO'' paradigm.Benett, 2002:144 The inclusion in the SQL syntax of statemen ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |