In Oracle 23c release you can now have a boolean data type in your table column, to illustrate:
I will create a dummy table and insert different values…note NULL is acceptable:
SQL> CREATE TABLE hr.example (id NUMBER, c1 BOOLEAN, c2 BOOL);
SQL> INSERT INTO hr.example VALUES (1, TRUE, NULL);
SQL> INSERT INTO hr.example VALUES (2, TRUE, 0);
SQL> INSERT INTO hr.example VALUES (3, TRUE, False);
SQL> INSERT INTO hr.example VALUES (4, 0, 1);
SQL> commit;
querying the table:
Filtering with TRUE values:
more information can be found here: