SQLize | PHPize | SQLtest

select 'Hello world' as txt, 7 * 6 as nmbr, sysdate as sdate; select true, false; create table bool_test ( val varchar2(10), flg boolean ); insert into bool_test values ('true' , true ); insert into bool_test values ('false' , false); insert into bool_test values ('null' , null ); insert into bool_test values ('t' ,'t' ); insert into bool_test values ('y' ,'y' ); insert into bool_test values ('yes' ,'yes' ); insert into bool_test values ('true' ,'true'); insert into bool_test values ('f' ,'f' ); insert into bool_test values ('False' ,'False'); insert into bool_test values ('FALSE' ,'FALSE'); insert into bool_test values ('FAlSE ' ,' FAlSe'); insert into bool_test values ('0' , 0 ); insert into bool_test values ('999' , 999 ); insert into bool_test values ('-10' , -10 ); select * from bool_test; insert into bool_test values ('f' ,'wtf' ); drop table IF EXISTS my_test; create table IF NOT EXISTS my_test (num number, txt varchar2(10));