Compound expressions

A compound expression is an expression composed of multiple types of expressions.

Syntax:

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

Where, the PRIOR operator is used for the CONNECT BY clause in a hierarchical query.

You can use any built-in function as an expression. However, inappropriate combinations of functions in compound expressions will be deprecated. For example, the LENGTH() function in unapproriate for aggregate functions.

The following examples are some valid compound expressions:

• ('WELL' 'SMITH')

• LENGTH('OCEANBASE') * 17

• SORT(221) + 32

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