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:
