Use an arithmetic expression to combine value expressions and
arithmetic operators. When you use an arithmetic expression in
a statement, Oracle Rdb calculates the value associated with the
expression and uses that value when executing the statement.
Therefore, an arithmetic expression must result in a value. If
either operand of an arithmetic expression is a missing value,
the resultant value also is a missing value.
Additional Information:
explode
extract