D Changes in Previous Releases

This appendix describes the changes that have occurred in the OLAP DML in previous releases. It contains the following topics:

D.1 OLAP DML Statement Changes for Oracle Database 11g

This section contains listings of the OLAP DML statements that were added, changed, renamed, or deleted in Oracle Database 11g:

D.1.1 Statements Added in Oracle Database 11g

The following statements have been added to the OLAP DML in Oracle Database 11g. The number in parentheses indicates the specific release in which the statement was added.

D.1.2 Statements Deleted in Oracle Database 11g

The following statements were deleted from the OLAP DML in Oracle Database 11g. The number in parentheses indicates the specific release in which the statement was deleted.

  • POUTFILEUNIT option (11.2)
  • SORTCOMPOSITE option

D.1.3 Statements Changed in Oracle Database 11g

The following statements have been changed in the OLAP DML in Oracle Database 11g. The number in parentheses indicates the most recent release in which the statement was changed.

D.1.4 Statements Renamed in Oracle Database 11g

No statements have been renamed in the OLAP DML in Oracle Database 11g.

D.2 OLAP DML Statement Changes for Oracle Database 10g

This section contains listings of the OLAP DML statements that were added, changed, renamed, or deleted in Oracle Database 10g:

D.2.1 Statements Added in Oracle Database 10g

The following statements were added to the OLAP DML in Oracle Database 10g. The number in parentheses indicates the specific release in which the statement was added.

D.2.2 Statements Deleted in Oracle Database 10g

The following statements were deleted from the OLAP DML in Oracle Database 10g. The number in parentheses indicates the specific release in which the statement was deleted.

  • AW ALLOCATE (10.1.0.0)
  • ROLLUP (10.2.0.0)

D.2.3 Statements Changed in Oracle Database 10g

The following OLAP DML statements were significantly changed in Oracle Database 10g. Examples of significant changes are the addition of a new keyword or a change in a default value. The number in parentheses indicates the last release in which the statement was significantly changed.

  • AGGMAPINFO (10.1.0.0)
  • AGGREGATE command (10.2.0.0)
  • AGGREGATE function (10.2.0.0)
  • ARGUMENT (10.1.0.0)
  • ANY (10.2.0.0)
  • AVERAGE (10.2.0.0)
  • AW function (10.2.0.0)
  • AW ATTACH (10.1.0.0)
  • CACHE (10.2.0.0)
  • CHGDFN (10.2.0.0)
  • CHGDIMS (10.1.0.3)
  • COUNT (10.2.0.0)
  • DEFINE COMPOSITE (10.1.0.0)
  • DEFINE VARIABLE (10.2.0.0)
  • DEPRDECL (10.2.0.0)
  • DEPRDECLSW (10.2.0.0)
  • DEPRSL (10.2.0.0)
  • DEPRSOYD (10.2.0.0)
  • EVERY (10.2.0.0)
  • FINTSCHED (10.2.0.0)
  • FPMTSCHED (10.2.0.0)
  • HIERCHECK (10.2.0.2)
  • LARGEST (10.2.0.0)
  • LIMIT command (10.2.0.0)
  • LIMIT function (10.2.0.0)
  • MAINTAIN ADD SESSION (10.1.0.0)
  • MAINTAIN ADD TO PARTITION (10.1.0.0)
  • NONE (10.2.0.0)
  • OBJ (10.2.0.3)
  • RANK (10.2.0.0)
  • RELATION (for aggregation) (10.2.0.0)
  • SMALLEST (10.2.0.0)
  • SORT command (10.1.0.3)
  • SQL (10.1.0.0)
  • STDDEV (10.2.0.0)
  • TALLY (10.2.0.0)
  • TOTAL (10.2.0.0)
  • UPDATE (10.1.0.0)
  • VARIABLE (10.1.0.0)
  • VALSPERPAGE (10.1.0.0)
  • VINTSCHED (10.2.0.0)
  • VPMTSCHED (10.2.0.0)

D.2.4 Statements Renamed in Oracle Database 10g

No OLAP DML statements have been renamed in Oracle Database 10g.

D.3 OLAP DML Statement Changes for Oracle Database 9i

This section contains listings of the OLAP DML statement changes in Oracle Database 9i.

D.3.1 Statements Added in Oracle Database 9i

The following statements were added to the OLAP DML in Oracle Database 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)
  • ALLOCERRLOCHEADER (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)

D.3.2 Statements Deleted in Oracle Database 9i

The following statements were deleted from the OLAP DML in Oracle Database 9i. The number in parentheses indicates the specific release in which the statement was deleted.

  • _UPDATEOLDVERS (9.2.0.0)
  • _XCALONGTIME (9.0.0.0)
  • _XCARETRIES (9.0.0.0)
  • _XCASHORTIME (9.0.0.0)
  • ALLOWQONS (9.2.0.0)
  • AW ALLOCATE (10.1.0.0)
  • CACHEHITS (9.2.0.0)
  • CACHEMISSES (9.2.0.0)
  • CACHETRIES (9.2.0.0)
  • CHARSET (9.0.0.0)
  • CHDIR (9.2.0.0)
  • CHDRIVE (9.2.0.0)
  • COMQUERY (9.0.0.0)
  • COMSET (9.0.0.0)
  • COMUNIT (9.0.0.0)
  • CONNECT (9.0.0.0)
  • DBEXTENDPATH (9.2.0.0)
  • DBGSESSION (9.2.0.0)
  • DBREPORT (9.2.0.0)
  • DBSEARCHPATH (9.2.0.0)
  • DBTEMPPATH (9.2.0.0)
  • DEFINE EXTCALL (9.0.0.0)
  • DGCART (9.2.0.0)
  • DIR (9.2.0.0)
  • DISCONNECT (9.0.0.0)
  • EPRODUCT (9.2.0.0)
  • ERELEASE (9.2.0.0)
  • EXECBREAK (9.0.0.0)
  • EXECSTART (9.0.0.0)
  • EXECSTATUS (9.0.0.0)
  • EXECUTE (9.0.0.0)
  • EXECWAIT (9.0.0.0)
  • EXTARGS (9.0.0.0)
  • FETCH (9.0.0.0) -- SNAPI
  • FILEMODEMASK (9.2.0.0)
  • IFCOPY (9.2.0.0)
  • LONGOBJNAMES (9.0.0.0)
  • MAXFETCH (9.0.0.0)
  • MKDIR (9.0.0.0)
  • NAPAGEFREE (9.2.0.0)
  • ODBC.CONNECTION (9.0.0.0)
  • ODBC.CONNLIST (9.0.0.0)
  • ODBC.DISCONN (9.0.0.0)
  • ODBC.SOURCE (9.0.0.0)
  • ODBC.SOURCELIST (9.0.0.0)
  • PGCACHEHITS (9.2.0.0)
  • PGCACHEMISSES (9.2.0.0)
  • PAGEPAUSE (9.2.0.0)
  • PAGEPROMPT (9.2.0.0)
  • PAUSE (9.2.0.0)
  • RETRIEVE (9.0.0.0)
  • RMDIR (9.0.0.0)
  • SESSIONQUERY (9.0.0.0)
  • SHARESESSION (9.0.0.0)
  • SHELL (9.0.0.0)
  • SQL CONNECT (9.0.0.0)
  • SQL DISCONNECT (9.0.0.0)
  • SQL.DMBS (9.0.0.0)
  • SQL.DMBSLIST (9.0.0.0)
  • STRIP (9.2.0.0)
  • THREADEXTCALL (9.0.0.0)
  • TRACE (9.2.0.0)
  • TRANSLATE (9.0.0.0)
  • TRANSPORT (9.0.0.0)
  • WATCH (9.2.0.0)
  • XABORT (9.0.0.0)
  • XCAPORTNUMBER (9.0.0.0)
  • XCLOSE (9.0.0.0)
  • XOPEN (9.0.0.0)

D.3.3 Statements Changed in Oracle Database 9i

The following OLAP DML statements were significantly changed in Oracle Database 9i and have not changed since then. Examples of significant changes are the addition of a new keyword or a change in a default value. The number in parentheses indicates the last release in which the statement was significantly changed. See also "Statements Renamed in Oracle Database 9i" for a list of renamed statements.

  • CONVERT (9.2.0.0)
  • DECIMALCHAR (9.2.0.0)
  • EXPORT (9.2.0.0)
  • FCQUERY (9.2.0.0)
  • FCSET (9.2.0.0)
  • FILEOPEN (9.0.0.0)
  • FILEQUERY (9.0.0.0)
  • FILEREAD (9.2.0.0)
  • HIERHEIGHT command (9.2.0.0)
  • IMPORT (9.0.0.0)
  • INFILE (9.0.0.0)
  • LAG (9.2.0.2)
  • LAGABSPCT (9.2.0.2)
  • LAGDIF (9.2.0.2)
  • LAGPCT (9.2.0.2)
  • LEAD (9.2.0.2)
  • MODEL (9.2.0.2)
  • MOVINGAVERAGE (9.2.0.2)
  • MOVINGMAX (9.2.0.2)
  • MOVINGMIN (9.2.0.2)
  • MOVINGTOTAL (9.2.0.2)
  • NOSPELL (9.2.0.0)
  • OUTFILE (9.0.0.0)
  • PROGRAM (9.2.0.0)
  • PROPERTY (9.0.0.0)
  • RECURSIVE (9.0.0.0)
  • RELATION (for aggregation) (9.2.0.2)
  • RELATION (for allocation) (9.2.0.2)
  • ROUND (9.0.0.0)
  • SYSDATE (9.2.0.0)
  • SYSINFO (9.2.0.2)
  • SYSTEM (9.2.0.0)
  • TALLY (10.2.0.0)
  • THOUSANDSCHAR (9.2.0.0)
  • YESSPELL (9.2.0.0)

D.3.4 Statements Renamed in Oracle Database 9i

The following OLAP DML statements were renamed in Oracle Database 9i. The number in parentheses indicates the specific release in which the statement was renamed.

  • DATABASE command to AW command (9.2.0.0)
  • DATABASE function to AW function (9.2.0.0)
  • DBDESCRIBE to AWDESCRIBE (9.2.0.0)
  • DBWAITTIME to AWWAITTIME (9.2.0.0)
  • DEFAULTDBFSIZE t o DEFAULTAWSEGSIZE (9.2.0.0)
  • OESEIFVERSION to EIFVERSION (9.2.0.0)

HCE