1. DML Reference
  2. Changes in Previous Releases

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:

Parent topic: Changes in Previous Releases

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.

Parent topic: OLAP DML Statement Changes for Oracle Database 11g

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

Parent topic: OLAP DML Statement Changes for Oracle Database 11g

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.

Parent topic: OLAP DML Statement Changes for Oracle Database 11g

D.1.4 Statements Renamed in Oracle Database 11g

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

Parent topic: OLAP DML Statement Changes for 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:

Parent topic: Changes in Previous Releases

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.

Parent topic: OLAP DML Statement Changes for Oracle Database 10g

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)

Parent topic: OLAP DML Statement Changes for Oracle Database 10g

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)

Parent topic: OLAP DML Statement Changes for Oracle Database 10g

D.2.4 Statements Renamed in Oracle Database 10g

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

Parent topic: OLAP DML Statement Changes for 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.

Parent topic: Changes in Previous Releases

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)

Parent topic: OLAP DML Statement Changes for Oracle Database 9i

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)

Parent topic: OLAP DML Statement Changes for Oracle Database 9i

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)

Parent topic: OLAP DML Statement Changes for Oracle Database 9i

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

Parent topic: OLAP DML Statement Changes for Oracle Database 9i