| application
programming
features |
| Scrollable
cursors: |
|
|
|
|
New cursor type in which you
can move both forwards and backwards through the result set. Can use either absolute row numbers
or relative row number offsets depending on your position in the result set. Additional memory
usage enhancements have been included for greater efficiency. |
|
| SQL
and PL/SQL integration: |
|
|
|
| This has been
tightened to improve performance. The overhead of calling PL/SQL procedures from SQL
has been reduced. |
|
| Enhanced
Unicode Support: |
|
|
|
| The NCHAR datatype
has been reclassified in 9i to be used exclusively for Unicode character sets UTF8 and
AL16UTF16. When specifying an NCHAR field length, you specify it in characters rather
than bytes meaning you do not have to worry about space issues for multibyte character sets.
Enhanced interoperability between NCHAR and other datatypes mean you can perform implicit
and explicit conversions between the two as for other types. |
|
| ANSI
compliant joins: |
|
|
|
| In an effort to improve portability
by standards compliance, left and right outer join syntax is now available as well as syntax for full
outer joins. |
|
| New
Date-Time datatypes: |
|
|
|
| Timezone-aware
datatypes can automatically account for timezone differences in applications that are
deployed globally. Using the time zone rules tables for a given region the time zone
offset for a local time can be calculated, taking into consideration Daylight Savings
time adjustments, and then used in further operations. |
|
| The
LONG API: |
|
|
|
| This is a new
API to help facilitate migrations from LONG to LOB datatypes. Helps ensure existing
applications require as few changes as possible. |
|
| XML
datatype: |
|
|
|
|
This new type stores
XML content as a Character Large Object (CLOB). A number of built-in member functions enable
developers to manipulate XML content. Additionally the XML type allows SQL operations on XML
content and vice versa. |
|
|
|
 |
| XML
SQL functions: |
|
|
|
| Two new SQL functions
have been added. SYS_XMLGEN allows dynamic production of XML documents from SQL select clauses.
SYS_XMLAGG can aggregate multiple rowset returns from SQL queries into a single enclosed
document. |
|
| XML
PL/SQL package: |
|
|
|
|
|
| The DBMS_XMLGEN package
allows you to create XML documents from any SQL query by mapping the query results into XML. |
|
| Enterprise
Java Engine: |
|
|
|
| The renamed JServer
from 8i comes with many new features, including the latest compliant engines for servlets
and Java Server Pages; enhanced Corba and EJB support; better JDBC driver integration
featuring type inheritance support and a native Java bytecode Accelerator and Memory
profiler, for deployment performance. |
|
| Java
Object Persistence: |
|
|
|
| Has now been implemented:
SQLJ object types can be associated with Java classes by using "create type" DDL.
This allows both Java and SQL developers to be able to access these objects with
ease meaning Java objects in the database can be stored and accessed in a standard way. |
|
| Oracle
Text: |
|
|
|
| Oracle Text
is the new name for InterMedia text as it is now a native feature. |
|
| Context
Enhancements: |
|
|
|
|
A new catalog index
type (CTXCAT) means that Context search performance features
can be used on data that exists in small chunks. New CTXRULE
index type has been introduced for document classification applications. |
|
| |
<<
previous page |
|
next
page >> |
|
020 8465 9100 
Sales
Enquiries
Other Enquiries
