Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Essential differences between PL/SQL v1 and v2?
On Sat, 19 Sep 1998 11:50:12 +0100, "Richard Fairbairn"
<zenith_at_technologist.com> wrote:
>Can someone tell me what the fundamental differences between PL/SQL v1 and
>v2 are?
>
>Thanks
>
>R. Fairbairn
>
>
This is documented on page 10 of the Oracle PL/SQL Programming book by Steve Feuerstein.
Version 2.0: Available with Release 7.0 (Oracle7 Server). Adds support for stored procedures, functions, packages, programmer-defined records, PL/SQL tables, and many package extensions, including DBMS_OUTPUT and DBMS_PIPE.
Release 2.1: Available with Release 7.1 of the Oracle7 Server. Supports programmer-defined subtypes, enables the use of stored functions inside SQL statements, and offers dynamic SQL with the DBMS_SQL package.
Release 2.2: Available with Release 7.2 of the Oracle7 Server. Implements a binary "wrapper" for PL/SQL programs to protect source code, supports cursor variables for embedded PL/SQL environments such as Pro*C, and makes available database-driven job scheduling with the DBMS_JOB package.
Release 2.3: Available with Release 7.3 of the Oracle7 Server. Enhances functionality of PL/SQL tables, offeres improved remote dependency management, adds file I/O capabilities to PL/SQL, and completes the implementation of cursor variables.
PL/SQL Release 8 adds support for external procedures, object types, collections, LOB types, and NLS types.
Thanks!
Joel
Joel R. Kallman Oracle Government, Education, & Health
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com