This section describes new features of the Oracle Database 10g Release 2 (10.2) and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.
The following sections describe the new features in Oracle Oracle Database 10g:
This section discusses new features introduced in Oracle Database 10g Release 1 (10.1).
Regular expression enhancements
This release adds SQL support for common Perl-based extensions that are not included but do not conflict with the POSIX standard.
Unicode datatype literal enhancement
You can avoid data loss if the database character set cannot represent all characters in the client character set.
Database Change Notification
Database Change Notification enables client applications to receive notifications when the result set of a registered query changes. For example, if the client registers a query of the hr.employees
table, and if a user adds an employee, then the application can receive a database change notification when a new row is added to the table. A new query of hr.employees
returns the changed result set.
Database Change Notification supports both mid-tier caches and server-side stored procedures. For example, a stored procedure that performs DML on registered tables can automatically send change notifications to a mid-tier application, which can keep cached data up to date.
Asynchronous Commit
Oracle Database enables you to change the handling of commit redo depending on the needs of your application. You can change the default COMMIT
options so that the application does not need to wait for Oracle Database to write data to the online redo logs.
Automatic Undo Retention Enhancement
This feature provides maximum retention for the fixed-size undo tablespace, thereby improving flashback capability as well as other statistic collection queries in which the query length is unknown.
Failover Improvements for Real Application Clusters (RAC) Distributed Transactions
Distributed Transactions in a RAC environment detect failures and start the failover and failback processes automatically.
XML DB Web Services
Enables direct access to the Oracle database through a native Web Service. Developers can write and deploy web services that can query the database with SQL or XQuery or execute stored procedures. You can access web services through the Oracle XML DB listener.
This section discusses new features introduced in Oracle Database 10g Release 1 (10.1).
Regular Expression Support
A set of SQL functions introduced in this release let you perform queries and manipulate string data by means of regular expressions. Refer to Chapter 4, "Using Regular Expressions in Oracle Database" for more information.
Oracle Expression Filter
Oracle Expression Filter lets you store conditional expressions in a column that you can use in the WHERE
clause of a database query. Refer to "Representing Conditional Expressions as Data" for more information.
Native floating-point datatypes
Column datatypes BINARY_FLOAT
and BINARY_DOUBLE
are introduced in this release. These datatypes provide an alternative to using the Oracle NUMBER
datatype, with the following benefits:
More efficient use of storage resources
Faster arithmetic operations
Support for numerical algorithms specified in the IEEE 754 Standard
Support for native floating-point datatypes in bind and fetch operations is provided for the following client interfaces:
SQL
PL/SQL
OCI
OCCI
Pro*C/C++
JDBC
Terabyte-Size Large Object (LOB) support
This release provides support for terabyte-size LOB values (from 8 to 128 terabytes) in the following programmatic environments:
Java (JDBC)
OCI
PL/SQL (package DBMS_LOB
)
You can store and manipulate LOB (BLOB
, CLOB
, and NCLOB
) datatypes larger than 4GB.
See Also: For details on terabyte-size LOB support: |
Flashback
This release has new and enhanced flashback features. You can now do the following:
Query the transaction history of a row.
Obtain the SQL undo syntax for a row and perform row-level flashback operations.
Perform remote queries of past data.
Oracle Data Provider for .NET
Oracle Data Provider for .NET (ODP.NET) is a new programmatic environment that implements a data provider for Oracle Database. It uses APIs native to Oracle Database to offer fast and reliable access from any .NET application to database features and data. ODP.NET also uses and inherits classes and interfaces available in the Microsoft .NET Framework Class Library.