SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data dictionary |
Informix® supports the BOOLEAN data type, which can store 't' or 'f' values. Genero BDL implements the BOOLEAN data type in a different way: As in other programming languages, Genero BOOLEAN stores integer values 1 or 0 (for TRUE or FALSE). The type was designed this way to assign the result of a boolean expression to a BOOLEAN variable.
Oracle does not implement a native BOOLEAN type in SQL types. However, a BOOLEAN type exists in the PL/SQL language.