A wish
Basic
. In Oracle SQL, a basic expression is really only a string, a value, a column, or perhaps a sequence reference within a SELECT statement list. For example, ‘My name is Joe.’
Compounding
. A compound expression is multiple expressions put together with operators. For example, 10 + 20 or P(1 + r) n
, a formula for compound interest calculations.
Lists
. A list of expressions such as (1, 2, x + y, (SELECT * FROM COUNTRY), ‘My name is Joe’ ).
Functions
. Any built-in or user-defined function comprises a functional expression. For example, the function POWER(2, 3) will
return 8.