All Products
Document Center

Compound expressions

Last Updated: Jun 18, 2021

A compound expression is an expression that is a combination of other types of expressions.

You can use a built-in function as an expression. However, in compound expressions, some combinations of functions are inappropriate and are discarded. For example, the LENGTH function is inapplicable in an aggregate function.

You can use the PRIOR operators in the CONNECT BY clauses of hierarchical queries.

The following list provides some valid compound expressions:

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