An operator is a symbol that specifies an action to be performed on one or two values (operands). For example, addition of two numbers.

The precedence in which the operators are evaluated is as follows:

Precedence Level Operators Meaning
1 +, -, PRIOR, CONNECT_BY_ROOT As unary operators (for example, in case of a negative number)
2 || Concatenation operators
3 *, / Multiplication and division
4 +, - Binary operators addition and subtraction

Exasol supports the following operators: