| application
programming |
| Regular
Expressions: |
|
|
|
 |
These
can now be used in SQL though the new REGEXP_LIKE, REGEXP_INSTR,
REGEXP_REPLACE and REGEXP_SUSBTR functions, leveraging this
powerful Unix-style functionality. |
|
| Binary
Float/Double Data Types: |
|
|
|
| These
new floating point data types are more efficient than the
number data type and are more widely accepted in the field
of computing. |
|
| 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. |
|
| Terabyte
LOB Support: |
|
|
|
| JDBC,
OCI & PL/SQL can now all handle terabyte LOBs. |
|
| DBMS_LOB
Enhancements: |
|
|
|
| Two
new procedures LOADBLOBFROMFILE and LOADCLOBFROMFILE allow
you to import external file content directly into LOB fields. |
|
| Oracle
Data Provider.net (ODP.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. |
|
| Case & Accent
Insensitive Queries: |
|
|
|
|
The
new NLS_SORT parameter can be used in queries to ignore case
and accents when sorting. |
|
|
|
|
|
| |
<<
previous page |
|
next
page >> |
|
020 8465 9100 
Sales
Enquiries
Other Enquiries
