What's New in the OLAP DML?
This section identifies the new features of the Oracle Database 11g that relate to the OLAP DML and lists the Oracle OLAP DML statements that were added, changed, renamed, or deleted in Oracle Database 9i and Oracle Database 10g.
New Features in the OLAP DML
In Oracle Database 11g, the following changes were made to the Oracle OLAP DML:
Also, as outlined in "Changes to the SQL OLAP_TABLE Function", there are several changes in the OLAP_TABLE SQL function which you can use to create relational views of OLAP DML data structures.
Table Privileges Needed When Working With Analytic Workspaces
In Oracle Database 11g, you must have the correct privileges to create and delete analytic workspaces. For more information, see "Privileges Needed to Create and Delete Analytic Workspaces".
Additional Support for Grouping Ids
In Oracle Database 11g, the following OLAP DML statements have been added or changed to offer more support for grouping ids:
Increased Support for Explicit Looping
In Oracle Database 11g, the following changes have been made to support explicit looping:
-
New WHERE clause in the ACROSS command that you can use to specify if the DO loop in that command is executed for an iteration of the loop.
-
New looping $LOOP_AGGMAP, $LOOP_DENSE, and $LOOP_VAR properties which are used by the OLAP_TABLE SQL function.
Additionally, in the limitmap parameter of the OLAP_TABLE SQL function there is support for a more complex Loop clause and a new Loop optimized clause.
Aggregation Improvements
In Oracle Database 11g, the following changes have been made to enhance aggregation:
-
Aggregation by partition. See AGGREGATE command for details
-
Clearing variables based on different aggmap objects. See the CLEAR command for details.
-
Checking to see if there are any changes in an aggmap since the last time a variable was aggregated using that aggmap. See the CHANGEDRELATIONS function for details.
-
Checking to see any value in a variable has changed (or the number of values that have changed) since the last time a variable was aggregated. See the CHANGEDVALUES function for details.
-
Checking to see if a variable or one or more of its partitions has values. See the ISEMPTY function for details.
-
Identifying the depth of a hierarchy. See the HIERDEPTH command for details.
-
Identifying the shape of a hierarchy. See the HIERSHAPE function for details.
Support for Analytic Workspace Caching
In Oracle Database 11g, the AW command has been modified to support caching which removes the time needed to open an analytic workspace for repeated queries
-
AW command has new PURGE CACHE keyword.
-
AW ATTACH command now uses the cached version of an analytic workspace if one is available rather than opening a current version.
-
AW DETACH command has a new CACHE keyword that specifies that an analytic workspace that is being detached is considered a candidate for caching.
-
AW TRUNCATE command has been improved
Support for Multi-Step Analytic Workspace Build Process
In Oracle Database 11g, the AW command has been modified as follows:
Additionally, the AW function has been modified to include a FROZEN keyword.
Additional Data Types
In Oracle Database 11g, the following OLAP DML data types have been added that correspond to SQL built-in data types:
The addition of these data types impacted the following OLAP DML statements:
- CHGDFN command
- CHARTOROWID function
- CONVERT function
- CURRENT_DATE function
- CURRENT_TIMESTAMP function
- DATE_FORMAT command
- DBTIMEZONE function
- DEFINE DIMENSION command
- DEFINE VARIABLE command
- EXTRACT function
- FROM_TZ function
- NUMTODSINTERVAL function
- NUMTOYMINTERVAL function
- LENGTH functions
- LOCALTIMESTAMP function
- ROUND (datetime) function
- ROWIDTOCHAR function
- ROWIDTONCHAR function
- SESSIONTIMEZONE function
- SYS_CONTEXT function
- TO_DSINTERVAL function
- TO_TIMESTAMP function
- TO_TIMESTAMP_TZ function
- TO_YMINTERVAL function
- TRUNCATE (datetime) function
- TZ_OFFSET function (11.0.0.0)
New SQL-Like Functions
In Oracle11g, the following functions, which are based on SQL functions of the same name, were added to the OLAP DML.
ASCIISTR
BIN_TO_NUM
HEXTORAW
INSTR functions
LNNVL
LOWER
MODULO (based on the SQL
MOD function)
NLS_CHARSET_ID
NLS_CHARSET_NAME
NLSSORT
ORA_HASH
RAWTOHEX
REGEXP_COUNT
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REMAINDER
REPLACE
SOUNDEX
TO_ BINARY_DOUBLE
TO_BINARY_FLOAT
UPPER
VSIZE
Additionally:
-
The OLAP DML LOG function was modified so that it corresponds more exactly to its SQL counterpart.
-
The new OLAP DML ISINFINITE and ISNAN functions provide information similar provided by the SQL floating point conditions.
Support for OLAP Cubes, Cube Dimensions, and Cube Materialized Views
With this release, "logical" OLAP objects (cube and cube dimensions) have been added as first-class Oracle data objects that are defined in the Oracle data dicitionary. These "logical" OLAP objects overlay a number of underlying "physical" OLAP objects that are defined in the analytic workspace itself.
Many of the Oracle Database OLAP features that are new in this release were added to support the use of OLAP cubes and cube materialized views:
Cube-aware OLAP DML statements
The following OLAP DML programs are provided that let you work with OLAP cubes and cube dimensions:
ADD_CUBE_MODEL
ADD_DIMENSION_MEMBER
ADD_MODEL_DIMENSION
CREATE_LOGICAL_MODEL
REMOVE_CUBE_MODEL
REMOVE_DIMENSION_MEMBER
REMOVE_MODEL_DIMENSION
SET_INCLUDED_MODEL
SET_PROPERTY
UPDATE_ATTRIBUTE_VALUE
UPDATE_DIMENSION_MEMBER
Also, the OBJORG function has been added so that you can use OLAP DML statements that are not cube-aware with OLAP cubes and cube dimensions.
Changes that insure optimal handling of analytic workspace data that corresponds to relational null facts
The following changes have been made to the OLAP DML so that it optimally handles OLAP data cells which correspond to relational null facts:
-
The DEFINE VARIABLE command now has a WITH NULLTRACKING phrase.
-
Two new functions, NA2 and NAFLAG , return values that Oracle OLAP uses to identify how an OLAP data value corresponds to a relational fact.
-
The CHGDFN command now includes syntax that adds or removes NA2 bits from a variable.
Typically, these OLAP DML statements are automatically generated during the process of creating a cube materialized view; you do not explicitly write DML code that uses these new features. These changes are documented in this manual so that you can understand the automatically-generated DML statements.
Changes in Export (EIF) and IMPORT (EIF)
Additionally, the default behavior of the EXPORT (EIF) and IMPORT (EIF) commands is to export and import cube metadata. There is a new keyword (NOAPI) that you can specify when you do not want this behavior.
Nested Composites Are No Longer Supported
In earlier releases of the OLAP DML, when you defined a composite using a DEFINE COMPOSITE command, you could specify a composite as a base object of another composite. This functionality was rarely, if ever, used. Beginning, in Oracle Database 11g, the base object of a composite can only be a dimension. If you have any nested composites in an existing analytic workspace, when you convert that analytic workspace into When you import nested composites from earlier versions into an Oracle Database 11g analytic workspace, IMPORT (EIF) automatically unnests the composites.
Additional Support for Retrieving Status List Values
In some cases there are multiple status lists for a dimension. You can use the new STATCURR function to retrieve a status list value based on from a status list based on the position of that list within the status list stack for the dimension.
Changes to the SQL OLAP_TABLE Function
OLAP_TABLE is a SQL function that extracts multidimensional data from an analytic workspace and presents it in the two-dimensional format of a relational table. As Oracle OLAP is more tightly integrated into Oracle Database 11g, you no longer must use a MODEL clause in a SELECT FROM OLAP_TABLE statement to enhance performance.
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:
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)
Statements Deleted in Oracle Database 11g
SORTCOMPOSITE option
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)
Statements Renamed in Oracle Database 11g
No statements have been renamed in the OLAP DML in Oracle Database 11g.
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:
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)
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)
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)
Statements Renamed in Oracle Database 10g
No OLAP DML statements have been renamed in Oracle Database 10g.
OLAP DML Statement Changes for Oracle Database 9i
This section contains listings of the OLAP DML statement changes in Oracle Database 9i.
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)
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)
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)
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)
