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.
- $GID_DEPTH system property (11.0.0.0)
- $GID_LIST system property (11.0.0.0)
- $GID_TYPE system property (11.0.0.0)
- $LOOP_AGGMAP system property (11.0.0.0)
- $LOOP_DENSE system property (11.0.0.0)
- $LOOP_VAR system property (11.0.0.0)
- ADD_CUBE_MODEL program (11.2)
- ADD_DIMENSION_MEMBER program (11.2)
- ADD_MODEL_DIMENSION program (11.2)
- AW FREEZE command (11.0.0.0)
- AW PURGE CACHE command (11.0.0.0)
- AW THAW command (11.0.0.0)
- ASCIISTR function (11.2)
- BIN_TO_NUM function (11.0.0.0)
- CHANGEDRELATIONS function (11.0.0.0)
- CHANGEDVALUES function (11.0.0.0)
- CHARTOROWID function (11.0.0.0)
- CREATE_LOGICAL_MODEL program (11.2)
- CURRENT_DATE function (11.0.0.0)
- CURRENT_TIMESTAMP function (11.0.0.0)
- DATE_FORMAT command (11.0.0.0)
- DBTIMEZONE function (11.0.0.0)
- EXTRACT function (11.0.0.0)
- FROM_TZ function (11.0.0.0)
- GROUPINGID function (11.0.0.0)
- HEXTORAW function (11.2)
- HIERDEPTH command (11.0.0.0)
- HIERSHAPE function (11.2)
- INSTR functions (11.0.0.0)
- ISEMPTY function (11.0.0.0)
- ISINFINITE function (11.2)
- ISNAN function (11.2)
- LENGTH functions (11.0.0.0)
- LNNVL function (11.0.0.0)
- LOCALTIMESTAMP function (11.0.0.0)
- LOWER function (11.2)
- MODULO function (11.0.0.0)
- NA2 function (11.0.0.0)
- NAFLAG function (11.0.0.0)
- NLS_CHARSET_ID function (11.2)
- NLS_CHARSET_NAME function (11.2)
- NLSSORT function (11.0.0.0)
- NUMTODSINTERVAL function (11.1.0.0)
- NUMTOYMINTERVAL function (11.1.0.0)
- OBJORG function (11.2)
- ORA_HASH function (11.2)
- PARTITION function (11.0.0.0)
- PERMITREADERROR option (11.2)
- RAWTOHEX function (11.2)
- REGEXP_COUNTfunction (11.2)
- REGEXP_INSTR function (11.2)
- REGEXP_REPLACE function (11.2)
- REGEXP_SUBSTR function (11.2)
- REMAINDER function (11.0.0.0)
- REMOVE_CUBE_MODEL program (11.2)
- REMOVE_DIMENSION_MEMBER program (11.2)
- REMOVE_MODEL_DIMENSION program (11.2)
- REPLACE function (11.0.0.0)
- ROWIDTOCHAR function (11.0.0.0)
- ROWIDTONCHAR function (11.0.0.0)
- SESSIONTIMEZONE function (11.0.0.0)
- SET_INCLUDED_MODEL program (11.2)
- SET_PROPERTY program (11.2)
- SOUNDEX function (11.2)
- STATCURR function (11.2)
- SYS_CONTEXT function (11.0.0.0)
- SYSTIMESTAMP function (11.0.0.0)
- TO_BINARY_DOUBLE function (11.2)
- TO_BINARY_FLOAT function (11.2)
- TO_DSINTERVAL function (11.0.0.0)
- TO_TIMESTAMP function (11.0.0.0)
- TO_TIMESTAMP_TZ function (11.0.0.0)
- TO_YMINTERVAL function (11.0.0.0)
- TRACE command (11.2)
- TZ_OFFSET function (11.0.0.0)
- UPDATE_ATTRIBUTE_VALUE program (11.2)
- UPDATE_DIMENSION_MEMBER program (11.2)
- UPPER function (11.2)
- VSIZE function (11.2)
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.
- ACROSS command (11.2)
- AGGREGATE command (11.0.0.0)
- AW function (11.0.0.0)
- AW ATTACH command (11.0.0.0)
- AW DETACH command (11.0.0.0)
- AW LIST command (11.0.0.0)
- AW TRUNCATE command (11.0.0.0)
- CHGDFN command (11.2)
- CLEAR command (11.0.0.0)
- CONVERT function (11.0.0.0)
- DEFINE COMPOSITE (11.0.0.0)
- DEFINE DIMENSION command (11.0.0.0)
- DEFINE PARTITION TEMPLATE (11.0.0.0)
- DEFINE VARIABLE command (11.0.0.0)
- EXPORT (EIF) command (11.2)
- GROUPINGID command (11.0.0.0)
- IMPORT (EIF) command (11.2)
- LOG function (11.0.0.0)
- OBJ function (11.2)
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.
- $AGGMAP property (10.1.0.0)
- $AGGREGATE_FORCECALC property (10.2.0.0)
- $AGGREGATE_FORCEORDER property (10.2.0.0)
- $AGGREGATE_FROM property (10.1.0.0)
- $AGGREGATE_FROMVAR property (10.1.0.0)
- $ALLOCMAP property (10.1.0.0)
- $COUNTVAR property (10.1.0.0)
- $DEFAULT_LANGUAGE property (10.2.0.0)
- ACQUIRE command (10.1.0.0)
- AGGCOUNT function (10.2.0.0)
- AGGMAP command, DROP DIMENSION statement (10.1.0.0)
- AGGMAP command, PRECOMPUTE statement (10.2.0.0)
- AGGROPS function (10.2.0.0)
- ALLOCMAP command, VALUESET statement (10.1.0.0)
- ALLOCOPS function (10.2.0.0)
- ARCTAN function (10.1.0.0)
- ASCII function (10.1.0.0)
- AW TRUNCATE command (10.1.0.3)
- BITAND function (10.1.0.0)
- CHR function (10.1.0.0)
- COALESCE function (10.1.0.0)
- DECODE function (10.1.0.0)
- DEFINE PARTITION TEMPLATE command (10.1.0.0)
- DROP DIMENSION statement of the AGGMAP command (10.1.0.0)
- EXP function (10.1.0.0)
- GREATEST function (10.1.0.0)
- INF_STOP_ON_ERROR option (10.1.0.0)
- INITCAP function (10.1.0.0)
- INSTR functions (INSTR and INSTRB) (10.1.0.0)
- LEAST function (10.1.0.0)
- LPAD function (10.1.0.0)
- LIMIT BASEDIMS command (10.2.0.0)
- LOCK_LANGUAGE_DIMS option (10.2.0.0)
- LTRIM function (10.1.0.0)
- MAXFETCH option (10.1.0.0)
- NULLIF function (10.1.0.0)
- NVL function (10.1.0.0)
- NVL2 function (10.1.0.0)
- ONATTACH program (10.1.0.0)
- PARTITIONCHECK function (10.1.0.0)
- PRECOMPUTE statement in AGGMAP command (10.2.0.0)
- RANK_CALLS option (10.2.0.0)
- RANK_CELLS option (10.2.0.0)
- RANK_SORTS option (10.2.0.0)
- RELATION command (10.2.0.0)
- RELEASE command (10.1.0.0)
- RESYNC command (10.1.0.0)
- REVERT command (10.1.0.0)
- RPAD function (10.1.0.0)
- RTRIM function (10.1.0.0)
- SESSION_NLS_LANGUAGE option (10.2.0.0)
- SET1 command (10.1.0.0)
- SIGN function (10.1.0.0)
- SORT function (10.2.0.0)
- SQLFETCH function (10.2.0.0)
- STATDEPTH function (10.2.0.0)
- STATEQUAL function (10.2.0.2)
- STATIC_SESSION_LANGUAGE option (10.2.0.0)
- SUBSTR functions, SUBSTR and SUBTRB (10.1.0.0)
- SUBSTR functions, SUBSTRC, SUBSTR2, and SUBSTR4 (10.2.0.4)
- TRANSLATE function (10.2.0.4)
- TRIGGER command (10.1.0.0)
- TRIGGER function (10.1.0.0)
- TRIGGER_DEFINE program (10.1.0.0)
- TRIGGER_AFTER_UPDATE program (10.1.0.0)
- TRIGGER_BEFORE_UPDATE program (10.1.0.0)
- TRIGGERASSIGN command (10.1.0.0)
- TRIM function (10.1.0.0)
- USETRIGGERS option(10.1.0.0)
- VALUESET statement in ALLOCMAP command (10.1.0.0)
- WIDTH_BUCKET function (10.1.0.0)
- WRAPERRORS option (10.2.0.0)
- WRITABLE function (10.2.0.0)
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.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