BOOLEAN Data Type. BOOLEAN can be used as a data type when defining a column in a table or a variable in a database procedure. Support for the BOOLEAN data type helps migrations from other database products. Boolean columns accept as input the SQL literals FALSE and TRUE.

What is BOOLEAN data type used for?

The BOOLEAN data type stores TRUE or FALSE data values as a single byte. The following table shows internal and literal representations of the BOOLEAN data type. You can compare two BOOLEAN values to test for equality or inequality. You can also compare a BOOLEAN value to the Boolean literals ' t ' and ' f '.

What is an example of Boolean data?

A Boolean expression is any expression that has a Boolean value. For example, the comparisons 3 < 5, x < 5, x < y and Age < 16 are Boolean expressions. The comparison 3 < 5 will always give the result true, because 3 is always less than 5.