First page Back Continue Last page Graphics

Oracle9i New Features


Notes:

External Tables provides for read only access of flat files as if they were an Oracle table. An access driver called ORACLE_LOADER makes this possible.
Flashback Query lets you run a query as if it were being run in the past. You can get results as if the data were in a state at a given point in time – in the past. The UNDO_RETENTION parameter to make this possible.
Pipelined Functions provides the means to start returning rows (piping rows) back to the caller before the function even completes.
With Resumable Space Management, a transaction that has encountered a space allocation error is suspended for a period of time - allowing you to fix the suspend condition and eventually allowing the transaction to resume.
ANSI JOIN Support allows one to write joins conformant to SQL92 syntax. They also allow one to write ‘full outer joins’ something that was not easily done up to now using the old syntax.
Enhanced OO Support provides more OO support including support for type evolution and inheritance.
Time zone support is available in timestamp datatypes and functions. Oracle maintains a db and session timezone for each session.
XML datatype support provides the means to hold native XML in a column of a table.