Oracle9i Database Migration Release 1 (9.0.1) Part Number A90191-02 |
|
This appendix lists the new internal datatypes and SQL functions added in version 8 and Oracle9i. This appendix covers the following topics:
Oracle9i SQL Reference for a complete list and descriptions of Oracle internal datatypes and SQL functions.
See Also:
The following sections list the new internal datatypes and SQL functions added in Oracle9i:
The internal datatypes listed in this section were added in Oracle9i. Each may be used as a function name in a SELECT
list, but only if it is qualified with a schema (schema.function) as in the following example:
select hr.true() ...
In release 8.0 and higher, if a schema qualification is missing, then these words generate an error, while in Oracle7, their unqualified use did not generate an error.
The following internal datatypes were added in release 9.0.1:
|
|
|
|
|
|
|
|
The SQL functions listed in this section are new in Oracle9i.
The following SQL functions were added in release 9.0.1:
The following sections list the new internal datatypes and SQL functions added in version 8:
The internal datatypes listed in this section were added in version 8. Each may be used as a function name in a SELECT
list, but only if it is qualified with a schema (schema.function) as in the following example:
select hr.true() ...
In release 8.0 and higher, if a schema qualification is missing, then these words generate an error, while in Oracle7, their unqualified use did not generate an error.
The following internal datatypes were added in release 8.0:
|
|
|
|
|
|
The following internal datatypes were added in release 8.1:
|
|
The SQL functions listed in this section are new in version 8.
The following SQL functions were added in release 8.0:
|
|
|
|
|
|
|
|
|
|
|
|
The following SQL functions were added in release 8.1:
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|