SQL Boolean Types

Name Description Syntax Aliases

boolean

state of true or false

true| false

1 | 0
True | False
'True' | 'False'

 
CREATE TABLE TEST_BOOLEAN (col_1 boolean, col2 string);
INSERT INTO TEST_BOOLEAN VALUES (TRUE, 'True Value');
INSERT INTO TEST_BOOLEAN VALUES (FALSE, 'False Value');

SELECT * FROM TEST_BOOLEAN;
 COL_1     COL2
 ------ -----------
 TRUE   True Value
 FALSE  False Value

SELECT * FROM TEST_BOOLEAN WHERE Col_1;
 COL_1     COL2
 ------ ----------
  TRUE  True Value

SELECT * FROM TEST_BOOLEAN WHERE not Col_1;
 COL_1     COL2
 ------ -----------
 FALSE  False Value

select 1 and 0 from dual;
 -----
 FALSE