Oracle introduced PL/SQL (version 1.0) in its Oracle Database product version 6.0 as the scripting language in SQL*Plus and programming language in SQL*Forms 3.
Since version 7, Oracle did a major upgrade for PL/SQL (version 2.0) that provides more features such as procedures, functions, packages, records, collections, and some package extensions.
Since then many features have been added to PL/SQL such as XML support, preprocessor, file I/O, object-orientation, new statements such as
CONTINUE and GOTO to make it one of the most highly structured programming languages.The History of PL/SQL
PL/SQL is Oracle’s Procedural Language extension to SQL. It is loosely based on Ada (a variant of Pascal developed for the US Dept of Defense). PL/SQL was first released in 1992 as an optional extension to Oracle 6.
PL/SQL is now a technology present in most Oracle servers and products.
PL/SQL Version: 1.0–1991 — Database Version: Oracle 6
- PL/SQL 1.0 had a debut as the Procedural Option with Oracle6. PL/SQL was implemented within SQL*Forms 3.0.
PL/SQL Version: 1.1–199x — Database Version: Oracle 6
- PL/SQL 1.1 supported client-side subprograms to execute stored code transparently.
PL/SQL Version: 2.0- 199x — Database Version: Oracle 7
- PL/SQL 2.0 with Oracle7 supported stored procedures, functions, packages, user-defined record types, PL/SQL tables and many package extensions, including DBMS_OUTPUT and DBMS_PIPE.
PL/SQL Version: 2.1–1991 — Database Version: Oracle 7.1
- PL/SQL 2.1 supported user-defined subtypes, use of stored functions inside SQL statements and dynamic SQL with the DBMS_SQL package.
PL/SQL Version: 2.2–199x — Database Version: Oracle 7.2
- PL/SQL 2.2 implemented wrapper for PL/SQL programs to protect source code, supported cursor variables and made database-driven job scheduling available with DBMS_JOB package.
PL/SQL Version: 2.3–199x — Database Version: Oracle 7.3
- PL/SQL 2.3 supported remote dependency management, file I/O within PL/SQL.
PL/SQL Version: 8.0–1999 — Database Version: Oracle 8
- PL/SQL 8.0 with Oracle8 supported LOBs, VARRAYs and Nested tables and Oracle Advanced Queuing functionality.
PL/SQL Version: 8.1 — Year 2000 — Database Version: Oracle 8i
- PL/SQL 8.1 with Oracle8i introduced Native Dynamic SQL, NOCOPY parameter option, Profiler, Bulk Binds, Autonomous Transactions, and new database triggers such as startup, shutdown, logon and logoff.
PL/SQL Version: 9.0 — Year 2001 — Database Version: Oracle 9i
- PL/SQL 9i supports Native compilation of PL/SQL, common SQL parser, integration of XML with SQL and PL/SQL with invocation of XMLType from PL/SQL, HTTP cookie support in PL/SQL, inheritance support in PL/SQL, PL/SQL CASE expressions, and globalized datatypes such as timestamp, interval, unichar, univarchar2 and uniclob.
PL/SQL Version: 10.0 — Year 2004 — Database Version: Oracle 10g
PL/SQL 10g compilation and runtime optimizations improve performance of all PL/SQL code without code changes. New compiler introduced support for compiler warnings. Added features included:
- the binary_float and binary_double datatypes (the IEEE datatypes).
- the regexp_like, regexp_instr, regexp_substr and regexp_replace builtins to support regular expression manipulation with standard POSIX syntax.
- multiset operations on nested table instances supporting operations like equals, union, intersect, except, member, and so on.
- the user-defined quote character.
- indices of and values of syntax for forall.
- the distinction between binary_integer and pls_integer vanishes.
PL/SQL Version: 10.2 — Year 2005 — Database Version: Oracle 10g
- PL/SQL Conditional complilation. (Selective, Inquiry, and Error directives)
PL/SQL Version: 11.0 — Year 2007 — Database Version: Oracle 11g
- PL/SQL real native compliation, Fine-grained dependency tracking, and PL/SQL function result cache.
0 comments:
Post a Comment