Note that I have highlighted in red those item that were of particular interest to me:
18.104.22.168 Web Services Support (Oracle Application Express)
- "Creating a PL/SQL API to interact with Web services"
- "Exposing report regions, DML processes as Representational State Transfer (REST) Web services."
- "Support of binary data types in Web services support"
- "Allow the inclusion of custom Simple Object Access Protocol (SOAP) headers with Web Services Description Language (WSDL) based Web services"
- "Support of SOAP 1.2 in wizard-based Web services support."
22.214.171.124 Enhanced Oracle Native LEFT OUTER JOIN syntax
- "...In Oracle Database 12c, the native syntax for a
LEFT OUTER JOINhas been expanded to allow multiple tables on the left hand side...Merging of such views allows more join reordering and, therefore, more optimal execution plans"
126.96.36.199 JDBC Support for PL/SQL Data Types as Parameters
- "The ability for Java and JDBC applications to bind PL/SQL package types and boolean types as parameters"
188.8.131.52 PL/SQL Functions Defined in the SQL WITH Clause
- "You can define a PL/SQL function in the
WITHclause of a subquery and use it as an ordinary function"
184.108.40.206 Temporal Validity
- "...you can add one or more valid time dimensions to a table using existing columns, or using columns automatically created by the database"
- "Flashback Query has been extended to support queries on Temporal Validity dimensions. Users can now execute queries with the
VERSIONS BETWEENclauses based on one or more valid time periods on the underlying tables"
220.127.116.11 IDENTITY Columns
- "Table columns have been enhanced to support the American National Standards Institute (ANSI) SQL keyword
18.104.22.168 Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types
- "The maximum size of the
RAWdata types has been increased from 4,000 to 32,767 bytes."
22.214.171.124 Native SQL Support for Query Limits and Row Offsets
OFFSETclauses provides native SQL language support to limit the number of rows returned and to specify a starting row for the return set."
126.96.36.199 Microsoft .NET Framework 4 and 4.5 Support
- "Oracle Data Provider for .NET supports .NET Framework 4 and 4.5, including Client Profile"
188.8.131.52 Database Support for JDK Upgrade
- "New support in this release allows a customer to upgrade...from JDK 1.6 to JDK 1.7 and conversely downgrade from JDK 1.7 to JDK 1.6"
184.108.40.206 JDBC Support for Database Resident Connection Pool
- "This feature allows large scale deployment of Java applications (typically hundreds or thousands of middle tier connecting to the same database). Orders of magnitude reductions of database server processes and memory are seen with this new feature"
220.127.116.11 Decision Tree Mining Text Data
18.104.22.168 Expected Maximization (EM) Clustering and Density Estimation
22.214.171.124 Feature Extraction Using Singular Value Decomposition
126.96.36.199 Feature Selection and Creation for Generalized Linear Models (GLM)
188.8.131.52 Native Double in Data Mining Functions
184.108.40.206 Native SQL Support for Row Pattern Matching
220.127.116.11 Native Text Support
18.104.22.168 On-the-Fly Models
22.214.171.124 Prediction Details and Cluster Functions
126.96.36.199 SecureFiles is the Default for the LOB Storage
- "In this release, SecureFiles is now the default for LOB storage when the compatible initialization parameter is set to 12.1 or higher."
188.8.131.52 Multitenant Architecture
- "The multitenant architecture is new in Oracle Database 12c Release 1 (12.1). You can have many PDBs inside a single Oracle Database occurrence. PDBs are fully backwards compatible with an ordinary pre-12.1 database."
- " Fast provisioning of a new database or of a copy of an existing database."
"Fast redeployment, by unplug and plug, of an existing database to a new platform."
"Quickly patch or upgrade the Oracle Database version for many databases and for the cost of doing it once."
"Patch or upgrade by unplugging a PDB and plugging it into a different CDB in a later version."
"A machine can run more database instances in the form of PDBs than as individual, monolithic databases."
- "Global Data Services (GDS) is a new capability of Oracle Database that extends the concept of services, which are only available in Oracle RAC, to a globally replicated configuration involving a combination of Oracle RAC, Active Data Guard, and Oracle GoldenGate. This allows services to be deployed anywhere within this globally replicated configuration, supporting load balancing, high availability, database affinity, and so on.
- "Customers who have utilized the concept of services for Oracle RAC can now extend the same benefits of automatic workload management to their Active Data Guard or Oracle GoldenGate configurations. Similarly, single-instance Active Data Guard or Oracle GoldenGate customers can now fully utilize the benefits of services and automatic workload management for their replicated configurations."
184.108.40.206 Oracle ASM Disk Scrubbing
- "Oracle ASM disk scrubbing is a new feature that checks logical data corruptions and repairs them automatically in normal and high redundancy disk groups. This feature is designed so that it does not have any impact on normal I/O in production systems. The scrubbing process repairs logical corruptions using the mirror disks. Disk scrubbing leverages the Oracle ASM rebalancing to minimize I/O overhead."
220.127.116.11 Enhanced ANYDATA Support
- "Restrictions have been removed from the
ANYDATAimplementation that prevented its use with Abstract Data Types (ADT) that contained attributes whose data type was
XMLType. This enhancement increases the flexibility of the Oracle
ANYDATAimplementation and it can now be used with database editions."
- "...adds support for W3C DOM Level 3 Core API's and reduces the memory footprint associated with using XML schemas."
"...extends Oracle's support for the W3C XQuery specification by adding support for the XQuery full text extension. This enables customers to perform XML-aware full text searches on XML content stored in the database."
18.104.22.168 Support for XQuery Update
- "...allowing users to perform fragment and node-level updates using the W3C standard query language."