Compound Expressions

A compound expression specifies a combination of other expressions.

compound_expression::=

Text description of compound_expression

Note that some combinations of functions are inappropriate and are rejected. For example, the LENGTH function is inappropriate within an aggregate function.

The PRIOR keyword is used in CONNECT BY clauses of hierarchical queries.

See Also: "Hierarchical Queries"

Some valid compound expressions are:

('CLARK' || 'SMITH') 
LENGTH('MOOSE') * 57 
SQRT(144) + 72 
my_fun(TO_CHAR(sysdate,'DD-MMM-YY')