Compound expressions

A compound expression is a combination of multiple types of expressions.

The syntax of a compound expression is as follows:

{ (expr)
| { + | - | PRIOR } expr
| expr { * | / | + | - | || } expr
}

In this syntax, the PRIOR operator is used in the CONNECT BY clause of a hierarchical query.

You can use any built-in function as an expression. However, some combinations of functions in compound expressions are deprecated because they are not suitable. For example, the LENGTH() function is not suitable for use with aggregate functions.

The following are some valid examples of compound expressions:

• ('WELL' || 'SMITH')

• LENGTH('OCEAN1BASE') * 17

• SORT(221) + 32

• my_func(TO_CHAR(sysdate, 'DD-MMM-YY'))