PolarDB for Oracle provides the standard SQL type BOOLEAN.

BOOLEAN can have one of only two states: TRUE or FALSE. A third state, UNKNOWN, is represented by the SQL NULL value.

Table 1. Boolean type
Name Storage size Description
BOOLEAN 1 Byte Logical Boolean (true/false)
Note
  • The valid value for representing the true state is TRUE.
  • The valid value for representing the false state is FALSE.