Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Working with Expressions, 4 of 14
An operator is a symbol that transforms a value or combines it in some way with another value.
The OLAP DML operators fall into the categories described in the following table.
Category |
Description |
---|---|
Arithmetic |
Operators that you can use in numeric expressions with numeric data to produce a numeric result. You can also use some arithmetic operators in date expressions with a mix of date and numeric data, which returns either a date or numeric result. For more information on arithmetic operators, see "OLAP DML arithmetic operators". |
Assignment |
An operator that you use to create an assignment statement that stores the results of an expression into an OLAP DML object. For more information on using assignment statements, see "Assigning Values to Data Objects". |
Comparison |
Operators that you can use to compare two values of the same basic type (numeric, text, date, or, in rare cases, Boolean) which returns a Boolean result. For more information on comparison operators, see "Boolean operators". |
Logical |
Operators that you can use to transform Boolean values using logical operations which returns a Boolean result. For more information on logical operators, see "Boolean operators". |
Substitution |
An operator that you can use to evaluate an expression and substitute the resulting value. For more information on the substitution operator, see "Substitution Expressions". |
Conditional |
Operators that you can use to select one of two values based on a Boolean condition. For more information on the substitution operator, see "Conditional Expressions". |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|