Using Operators and Functions in Queries

The select_list of a query can include SQL expressions, which can include SQL operators and SQL functions. These operators and functions can have table data as operands and arguments. The SQL expressions are evaluated, and their values appear in the results of the query.

This section contains:

• Using Arithmetic Operators in Queries

• Using Numeric Functions in Queries

• Using the Concatenation Operator in Queries

• Using Character Functions in Queries

• Using Datetime Functions in Queries

• Using Conversion Functions in Queries

• Using Aggregate Functions in Queries

• Using NULL-Related Functions in Queries

• Using CASE Expressions in Queries

• Using the DECODE Function in Queries