oplaTech About Teaching Archive
Oplatek's external memory

Boolean in oracle

Found answer here


CREATE TABLE MyTable (
/* original */
MyBool CHAR(1) CHECK (MyBool IN ( 'Y', 'N' )),
/* little bit more readable for me */
MyColumnBool CHAR(1) CHECK (MyColumnBool IN ( 'Y', 'N' ))
);


These columns have the same size as bool (one byte, one char),