Introduction :
In additional to the changes made to Oracle Application Express 4.2 to work within the new Oracle Database 12c Multitenant Architecture, additional changes have also been made to accommodate some other Oracle Database 12c new features.
Oracle Database 12c includes :
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
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.
The INVISIBLE clause can be specified within CREATE / ALTER TABLE statements. This clause is used to define user-specified hidden columns.
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 run time (query-execution time).
Conclusion
The above new features which may be important to Oracle Application Express developers in Oracle Database 12c.
