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.

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).