Database SQL Language Reference
ContentsOpens a new window
Opens a new window
Page 43 of 554

Compound Expressions

A compound expression specifies a combination of other expressions.

compound_expression::=

Description of compound_expression.gif follows
Description of the illustration compound_expression.gifOpens a new window

You can use any built-in function as an expression ("Function Expressions"Opens a new window). However, in a compound expression, some combinations of functions are inappropriate and are rejected. For example, the LENGTH function is inappropriate within an aggregate function.

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

See Also:

"Operator Precedence"Opens a new window and "Hierarchical Queries"Opens a new window

Some valid compound expressions are:

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