Skip Headers

Oracle9i SQL Reference
Release 2 (9.2)

Part Number A96540-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

Compound Expressions

A compound expression specifies a combination of other expressions.

compound_expression::=

Text description of expressions6.gif follows
Text description of compound_expression



Note:

You can use any built-in function as an expression ("Function Expressions"). 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" and "Hierarchical Queries"

Some valid compound expressions are:

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