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

  • September 21, 2014 | 164 views