The following list shows the order in which Oracle CDD/Repository
interprets symbols used in an expression:
1. (symbols)
Any field contained in parentheses.
2. * /
Multiplication and division symbols.
3. +
Addition and subtraction symbols.
4. < > <= >= = <>
Relational operators. See Expressions relational_operators for
more information.
5. NOT
Logical operator.
6. AND
Logical operator.
7. OR
Logical operator.
Relational Operators Equivalent Symbols shows equivalent symbols
for the relational operators shown in the Precedence Ordering
within Expressions table.
Table 5-1 Relational Operators Equivalent Symbols
Relational Equivalent
Operator Symbol Meaning
< LT Less than
> GT Greater than
<= LE Less than or equal to
>= GE Greater than or equal to
<> NE Not equal to
In general, CDO evaluates expressions from left to right. When
an expression contains parentheses or operators, CDO evaluates
these operations first. The following list shows the order of
precedence for these symbols, from highest to lowest:
o A symbol or symbols within parentheses
o Multiplication or division symbols
o Addition or subtraction symbols
o Relational operators: LT, GT, LE, GE, EQ, NE
o NOT
o AND
o OR
In the following example, the order of precedence determines that
the first expression evaluates to 3, while the second expression
evaluates to 8.
(6 + 12)/6 = 3
6 + 12/6 = 8
In the following expression, CDO evaluates X as a value between 2
and 4 or 11 and 20.
IF (X GE 2 AND X LE 4) OR (X GE 11 AND X LE 20) THEN 1 ELSE 0