Oracle Application Express in Oracle Database 12c

Oracle Application Express in Oracle Database 12c

Oracle Application Express Release 4.2.0.00.08 is installed by default in Oracle Database 12c. One of the major new capabilities introduced in Oracle Database 12c is Multitenant Architecture.

Oracle Database 12c New Features for Application Express Developers

VARCHAR2 32K (Extended Data Type)
The byte / character limit for VARCHAR2 columns can be extended from 4000 to 32,767 by changing the MAX_STRING_SIZE database parameter to EXTENDED.

DEFAULT | DEFAULT ON NULL Table Clause
The DEFAULT and DEFAULT ON NULL clause can be specified within CREATE / ALTER TABLE statements. These parameters allow you to specify a value to be assigned to the column if a subsequent INSERT statement omits a value for the column, or the value evaluates to NULL

IDENTITY Table Clause
The IDENTITY clause can be specified within CREATE / ALTER TABLE statements. Use this clause to assign an increasing or decreasing integer from a sequence generator for each subsequent INSERT statement. This can be utilized instead of needing to specify a separate database sequence, and related table triggers or other processes, to retrieve an integer value.

INVISIBLE Column Clause
The INVISIBLE clause can be specified within CREATE / ALTER TABLE statements. This clause is used to define user-specified hidden columns.

SELECT "ROW_LIMITING" Clause
The ROW_LIMITING clause has a number of available settings. Use this clause to limit the rows returned by a query

Data Redaction
Oracle Data Redaction is the ability to redact data, typically sensitive data, in real time. Using redaction database profiles, data returned from a query can be masked for low-privileged users or applications at runtime (query-execution time).