Table of Contents Previous Next


1 Introduction : 1.1 What’s New

The following database compatibility for Oracle features have been added to Advanced Server 11 to create Advanced Server 12:
Advanced Server introduces COMPOUND TRIGGERS, which are stored as a PL block that executes in response to a specified triggering event. For information, see the Database Compatibility for Oracle Developer’s Guide. For affected SPL programs, see Section 2.3.35.
Advanced Server now supports new DATA DICTIONARY VIEWS that provide information compatible with the Oracle data dictionary views. For information, see Sections 3.4, 3.6, 0, 3.34, 3.37, 3.57, 3.67, 3.69, and 3.85.
Advanced Server has added the LISTAGG function to support string aggregation that concatenates data from multiple rows into a single row in an ordered manner. For information, see Section 2.4.11.1.
Advanced Server now supports CAST(MULTISET)function, allowing subquery output to be CAST to a nested table type. For information, see Section 2.1.3.3.
Advanced Server has added the MEDIAN function to calculate a median value from the set of provided values. For information, see Section 2.4.11.2.
Advanced Server has added the SYS_GUID function to generate and return a globally unique identifier in the form of 16-bytes of RAW data. For information, see Section 2.4.4.2.
Advanced Server now supports an Oracle-compatible SELECT UNIQUE clause in addition to an existing SELECT DISTINCT clause. For information, see Section 2.3.71.11.
Advanced Server has re-implemented default_with_rowids to create a table that includes a ROWID column in the newly created table. For information, see the EDB Postgres Advanced Server Guide.
Advanced Server introduces INTERVAL PARTITONING, which allows a database to automatically create partitions of a specified interval as new data is inserted into a table. For information, see the Database Compatibility for Oracle Developer’s Guide.

1 Introduction : 1.1 What’s New

Table of Contents Previous Next