Overview

An operator manipulates individual operands or arguments and returns a result. Syntactically, an operator can appear before an operand, after an operand, or between two operands.

OceanBase Database supports unary and binary operators:

• Unary operator

  A unary operator manipulates only on one operand. Unary operators and operands are written in the following format:

  Operator operand
  

• Binary operators

  A binary operator manipulates two operands. Binary operators and operands are written in the following format:

  Operand1 operator operand2
  

Note

• Other operators with special formats can manipulate more than two operands.
• If an operator is given a null operand, the result is NULL in most cases. The only exception is the concatenation operator ().

OceanBase Database supports the following operators:

• Arithmetic operators

• Bitwise operators

• Comparison operators

• Logical operators

• Date and time operators

• Concatenation operators