E
New Internal Datatypes and SQL Functions

This appendix lists the new internal datatypes and SQL functions added in version 8 and Oracle9i. This appendix covers the following topics:

• Internal Datatypes and SQL Functions Added in Oracle9i

• Internal Datatypes and SQL Functions Added in Version 8

  See Also: Oracle9i SQL Reference for a complete list and descriptions of Oracle internal datatypes and SQL functions.

Internal Datatypes and SQL Functions Added in Oracle9i

The following sections list the new internal datatypes and SQL functions added in Oracle9i:

• Internal Datatypes Added in Oracle9i

• SQL Functions Added in Oracle9i

Internal Datatypes 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.

Internal Datatypes Added in Release 9.0.1

The following internal datatypes were added in release 9.0.1:

AnyData	AnyDataSet
AnyType	INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH	TIMESTAMP
XMLType

SQL Functions Added in Oracle9i

The SQL functions listed in this section are new in Oracle9i.

SQL Functions Added in Release 9.0.1

The following SQL functions were added in release 9.0.1:

ASCIISTR	BIN_TO_NUM
COALESCE	COMPOSE
CURRENT_DATE	CURRENT_TIMESTAMP
DBTIMEZONE	DECOMPOSE
EXISTSNODE	EXTRACT
FIRST	FROM_TZ
GROUP_ID	GROUPING_ID
LAST	LOCALTIMESTAMP
NULLIF	PERCENTILE_CONT
PERCENTILE_DISC	RAWTONHEX
ROWIDTONCHAR	SESSIONTIMEZONE
SYS_DBURIGEN	SYS_EXTRACT_UTC
SYS_XMLAGG	SYS_XMLGEN
SYSTIMESTAMP	TO_CHAR
TO_CLOB	TO_DSINTERVAL
TO_NCHAR	TO_NCLOB
TO_TIMESTAMP	TO_TIMESTAMP_TZ
TO_YMINTERVAL	TREAT
TZ_OFFSET	UNISTR
WIDTH_BUCKET

Internal Datatypes and SQL Functions Added in Version 8

The following sections list the new internal datatypes and SQL functions added in version 8:

• Internal Datatypes Added in Version 8

• SQL Functions Added in Version 8

Internal Datatypes 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.

Internal Datatypes Added in Release 8.0

The following internal datatypes were added in release 8.0:

BFILE	BLOB
CLOB	NCHAR
NCLOB	NVARCHAR2

Internal Datatypes Added in Release 8.1

The following internal datatypes were added in release 8.1:

UROWID (universal rowid)

SQL Functions Added in Version 8

The SQL functions listed in this section are new in version 8.

SQL Functions Added in Release 8.0

The following SQL functions were added in release 8.0:

BFILENAME	DEFEF
EMPTY_BLOB	EMPTY_CLOB
MAKE_REF	NLS_CHARSET_DECL_LEN
NLS_CHARSET_ID	NLS_CHARSET_NAME
REF	REFTOHEX
VALUE

SQL Functions Added in Release 8.1

The following SQL functions were added in release 8.1:

BITAND	CORR
COVAR_POP	COVAR_SAMP
CUME_DIST	DENSE_RANK
FIRST_VALUE	GROUPING
LAG	LAST_VALUE
LEAD	NTILE
NUMTOYMINTERVAL	NUMTODSINTERVAL
NVL2	PERCENT_RANK
RATIO_TO_REPORT	REGR_ (linear regression) functions
STDDEV_POP	STDDEV_SAMP
SYS_CONTEXT	SYS_GUID
TO_LOB	TRIM
VAR_POP	VAR_SAMP

Note: Function names beginning with SYS are reserved by Oracle. You should not begin any function names with SYS; if you do, then you may encounter compatibility problems.