An operator is typically used to combine individual data items such as operands or parameters and return a result. Syntactically, an operator can appear before an operand, after an operand, or between two operands.
Common operators can also be classified as unary and binary operators:
Unary operators
A unary operator operates on a single operand. The general format of a unary operator is as follows:
Operator OperandBinary operators
A binary operator performs an operation on two operands. The general format of a binary operator is as follows:
Operand 1 Operator Operand 2Note
- Other operators with special formats can accept more than two operands.
- If an operator is provided with a null operand
NULL, the result is always null. The only exception to this rule is the character concatenation operator (||).
OceanBase AI Database currently supports the following operators: