|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. An expression generally assumes the datatype of its components.
This simple expression evaluates to 4 and has datatype
NUMBER (the same datatype as its components):
The following expression is an example of a more complex expression that uses both functions and operators. The expression adds seven days to the current date, removes the time component from the sum, and converts the result to
You can use expressions in:
VALUESclause of the
SETclause of the
For example, you could use an expression in place of the quoted string 'smith' in this
SET clause has the expression
last_name) instead of the quoted string '
Expressions have several forms, as shown in the following syntax:
Oracle does not accept all forms of expressions in all parts of all SQL statements. You must use appropriate expression notation whenever
expr appears in conditions, SQL functions, or SQL statements in other parts of this reference. The sections that follow describe and provide examples of the various forms of expressions.