The Boolean data type stores the logical values that are used in the logical operations. These logical values are the Boolean values TRUE or FALSE and also the value NULL. And also, SQL has no data type equivalent to the BOOLEAN. However, Boolean values cannot used in –
- SQL statements
- Built-in SQL functions (such as TO_CHAR)
- PL/SQL functions invoked from the SQL statements.