Posted On: Apr 2, 2015
You can now launch Amazon RDS instances running Oracle 12c. Oracle 12c introduced many new features, such as Data Redaction, Adaptive Query Optimization, inline PL/SQL functions and procedures, support for "top N" queries, Oracle Application Express (APEX) 4.2, and others.
Data Redaction is designed to allow you to mask sensitive data fields such as credit-card numbers and personally identifiable information (like U.S. Social Security numbers). Adaptive Query Optimization allows the query optimizer to adjust execution plans based on statistics gathered at statement execution time, improving query performance. You can now define stored procedures and functions in the WITH clause and use these inline objects in your queries. You can also limit the results of your queries to the top N records more easily.
To create a new Oracle 12c database instance with just a few clicks in the AWS Management Console, use the "Launch DB Instance" wizard and select the DB engine version "126.96.36.199.v1". This DB engine version supports APEX version 4.2.6.