why not have boolean type£¿

[oceanju]

why not have boolean type in oracle? Which type can take the place in boolean type?
Please help
thanks

[prafful]

Database itself doen't have BOOLEAN type but PL/SQL do.

In database (tables), instead of BOOLEAN you have to use VARCHAR2 and values as Y and N or 1 or 0 or whatever you want (may be 'TRUE' and 'FALSE') - then you have to treat
this values as you desire.

There is no direct BOOLEAN type available for Oracle Database.

Hope this helps.

[oceanju]

I prepared to use char(1).
thanks very much.