This section lists the Oracle compatibility features that have been added since EnterpriseDB Advanced Server 8.2.
● The configuration parameter edb_redwood_strings allows treatment of a null variable or column as an empty string instead of a null value for string concatenation purposes. See Section 1.3.2 for information on edb_redwood_strings.
● The configuration parameter edb_stmt_level_tx restricts automatic rollback of an aborted SQL command to just that one command rather than all SQL commands in the transaction. See Section 1.3.3 for information on edb_stmt_level_tx.
● The configuration parameter edb_stmt_level_tx restricts automatic rollback of an aborted SQL command to just that one command rather than all SQL commands in the transaction. See Section 1.3.3 for information on edb_stmt_level_tx.
● The configuration parameter oracle_home directs Postgres Plus Advanced Server to the correct Oracle Home directory in the file system. See Section 1.3.4 for information on oracle_home.
● Database links are now supported in the DELETE, INSERT, SELECT, and UPDATE commands. See the CREATE DATABASE LINK command and the DROP DATABASE LINK command.
● The DELETE, SELECT, and UPDATE commands now support optimizer hints that force the optimizer to use a specified execution plan. See Section 3.4 for information on optimizer hints.
● The CREATE FUNCTION, CREATE PROCEDURE, and CREATE PACKAGE commands now support the AUTHID DEFINER and AUTHID CURRENT_USER clauses to determine whether the privileges of the program owner or those of the current user executing the program are to be used to validate access rights to database objects referenced by the program. These clauses also determine which user’s search path is to be used to resolve unqualified object references. See Section 4.2.6 for additional information on SPL program security.
● The CREATE SEQUENCE command now supports the NOMINVALUE and NOMAXVALUE clauses to specify usage of the default minimum value or the default maximum value for a sequence, respectively.
● The FORALL statement allows a DELETE, INSERT, or UPDATE command to pass one or more collections of values to the database server. This eliminates the overhead associated with repeatedly executing the command with the different values. See Section 4.9.3 for information on using the FORALL statement.
● The BULK COLLECT clause can now be used to retrieve the result set of a SELECT INTO, FETCH, DELETE RETURNING, INSERT RETURNING, or UPDATE RETURNING command into a collection. See Section 4.9.4.
● The EDB*Plus utility program provides a SQL*Plus compatible command line terminal interface. See Section 10.1.
