OceanBase AI Database supports character concatenation operators.
The following table describes the character concatenation operators supported by the current version of OceanBase AI Database.
operator |
operand |
Meaning |
|---|---|---|
\|\| |
binary | String concatenation |
The || operator can be used as a logical OR operator, which is controlled by the sql_mode setting:
When
sql_modeincludesPIPES_AS_CONCAT,||is a character concatenation operator.If
sql_modedoes not containPIPES_AS_CONCAT,||is a logical OR operator.