1. Expression Syntax Reference
  2. Reserved Words

A Reserved Words

This appendix lists the reserved words for the OLAP expression syntax.

A.1 Reserved Words

The following are reserved words for the OLAP Expression Syntax. You should not use them or Oracle Database reserved words as object names. However, if you do, be sure to enclose them in double quotes in the expression syntax.

Refer to the Oracle Database SQL Language Reference for a list of Oracle Database reserved words.

  • AGGREGATE
  • AGGREGATES
  • ALL
  • ALLOW
  • ANALYZE
  • ANCESTOR
  • AND
  • ANY
  • AS
  • ASC
  • AT
  • AVG
  • BETWEEN
  • BINARY_DOUBLE
  • BINARY_FLOAT
  • BLOB
  • BRANCH
  • BUILD
  • BY
  • BYTE
  • CASE
  • CAST
  • CHAR
  • CHILD
  • CLEAR
  • CLOB
  • COMMIT
  • COMPILE
  • CONSIDER
  • COUNT
  • DATATYPE
  • DATE
  • DATE_MEASURE
  • DAY
  • DECIMAL
  • DELETE
  • DESC
  • DESCENDANT
  • DIMENSION
  • DISALLOW
  • DIVISION
  • DML
  • ELSE
  • END
  • ESCAPE
  • EXECUTE
  • FIRST
  • FLOAT
  • FOR
  • FROM
  • HIERARCHIES
  • HIERARCHY
  • HOUR
  • IGNORE
  • IN
  • INFINITE
  • INSERT
  • INTEGER
  • INTERVAL
  • INTO
  • IS
  • LAST
  • LEAF_DESCENDANT
  • LEAVES
  • LEVEL
  • LEVELS
  • LIKE
  • LIKEC
  • LIKE2
  • LIKE4
  • LOAD
  • LOCAL
  • LOG_SPEC
  • LONG
  • MAINTAIN
  • MAX
  • MEASURE
  • MEASURES
  • MEMBER
  • MEMBERS
  • MERGE
  • MLSLABEL
  • MIN
  • MINUTE
  • MODEL
  • MONTH
  • NAN
  • NCHAR
  • NCLOB
  • NO
  • NONE
  • NOT
  • NULL
  • NULLS
  • NUMBER
  • NVARCHAR2
  • OF
  • OLAP
  • OLAP_DML_EXPRESSION
  • ON
  • ONLY
  • OPERATOR
  • OR
  • ORDER
  • OVER
  • OVERFLOW
  • PARALLEL
  • PARENT
  • PLSQL
  • PRUNE
  • RAW
  • RELATIVE
  • ROOT_ANCESTOR
  • ROWID
  • SCN
  • SECOND
  • SELF
  • SERIAL
  • SET
  • SOLVE
  • SOME
  • SORT
  • SPEC
  • SUM
  • SYNCH
  • TEXT_MEASURE
  • THEN
  • TIME
  • TIMESTAMP
  • TO
  • UNBRANCH
  • UPDATE
  • USING
  • VALIDATE
  • VALUES
  • VARCHAR2
  • WHEN
  • WHERE
  • WITHIN
  • WITH
  • YEAR
  • ZERO
  • ZONE

A.2 Special Symbols

Table A-1 lists symbols that are used in the OLAP expression syntax. To enter them as literal characters, enclose them in quotes the same as any other literal text.

Table A-1 OLAP Expression Syntax Symbols

Symbol Description

,

Comma

||

Concatenate

/

Divide

=

Equals

>

Greater than

>=

Greater than or equal to

[

Left bracket

(

Left parenthesis

<

Less than

<=

Less than or equal to

-

Minus

!=

Not equal to

<>

Not equal to

ˆ=

Not equal to

+

Plus

]

Right bracket

)

Right parenthesis

*

Star