Oracle7 Server SQL Reference

Changes to the Optional Components of Oracle

This section discusses the differences in the optional components between Oracle Version 6 and Oracle7.

With Oracle Version 6, the transaction processing option was available. This option included these features:

row-level locking

PL/SQL

With Oracle7, the transaction processing option is obsolete. However, these options are available:

procedural option

This option includes PL/SQL and allows you to use anonymous PL/SQL blocks, stored procedures, stored functions, stored packages, and database triggers.

distributed option

This option allows you to issue Data Manipulation Language (DELETE, EXPLAIN PLAN, LOCK TABLE, INSERT, and UPDATE) statements that modify data on remote databases.

Parallel Server option

This option allows multiple Oracle instances to mount an Oracle7 database in parallel mode. This functionality was also available in Oracle Version 6.2.

To use snapshots, you must have both the procedural option and the distributed option. All other features of Oracle7 (including row-level locking) are available in all installations and do not require one of these options.