Statements Added in Oracle 9i
|
The following statements were added to the OLAP DML in Oracle 9i. The number in parentheses indicates the specific release in which the statement was added.
ADD_MONTHS (9.0.0.0)
ALLOCATE (9.2.0.0)
ALLOCERRLOGFORMAT (9.2.0.0)
ALLOCERRLOGHEADER (9.2.0.0)
ALLOCMAP (9.2.0.0)
BASEDIM (9.2.0.0)
BASEVAL (9.2.0.0)
CDA (9.2.0.0)
CEIL (9.0.0.0)
CHANGEBYTES (9.0.0.0)
CHGDIMS (9.2.0.0)
CHILDLOCK (9.2.0.0)
COMMIT (9.2.0.0)
DEADLOCK (9.2.0.0)
ERRORLOG (9.2.0.0)
ERRORMASK (9.2.0.0)
EXTBYTES (9.0.0.0)
FETCH (9.2.0.0)
FINDBYTES (9.0.0.0)
FLOOR (9.0.0.0)
GROUPINGID (9.2.0.0)
HIERHEIGHT command (9.2.0.0)
HIERHEIGHT function (9.2.0.0)
INSBYTES (9.0.0.0)
JOINBYTES (9.0.0.0)
LAST_DAY (9.0.0.0)
LIMITMAPINFO (9.2.0.2)
LIMITSTRICT (9.2.0.2)
MAXBYTES (9.0.0.0)
MAXFETCH (9.0.0.0)
MONTHS_BETWEEN (9.0.0.0)
MULTIPATHHIER (9.0.0.0)
NEW_TIME (9.0.0.0)
NEXT_DAY (9.0.0.0)
NLS Options, specifically:
- NLS_CALENDAR (9.0.0.0)
- NLS_CURRENCY (9.0.0.0)
- NLS_DATE_FORMAT (9.0.0.0)
- NLS_DATE_LANGUAGE (9.0.0.0)
- NLS_DUAL_CURRENCY (9.0.0.0)
- NLS_ISO_CURRENCY (9.0.0.0)
- NLS_LANG (9.0.0.0)
- NLS_LANGUAGE (9.0.0.0)
- NLS_NUMERIC_CHARACTERS (9.0.0.0)
- NLS_SORT (9.0.0.0)
- NLS_TERRITORY (9.0.0.0)
NULLIF (9.0.0.0)
POUTFILEUNIT (9.2.0.0)
REMBYTES (9.0.0.0)
REPLBYTES (9.0.0.0)
ROLE (9.0.0.0)
SOURCEVAL (9.2.0.0)
SYSDATE (9.0.0.0)
TO_CHAR (9.0.0.0)
TO_DATE (9.0.0.0)
TO_NCHAR (9.2.0.0)
TO_NUMBER (9.0.0.0)
TRACEFILEUNIT (9.2.0.0)
TRIM (9.0.0.0)
USERID (9.0.0.0)