Sunday, 21 September 2014

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

2 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  2. I really appreciate the information shared above. It’s of great help. If someone wants to learn Online (Virtual) instructor lead live training in Oracle Application Express TECHNOLOGY, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor-led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ pieces of training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Pratik Shekhar
    MaxMunus
    E-mail: pratik@maxmunus.com
    Ph:(0) +91 9066268701
    http://www.maxmunus.com/

    ReplyDelete