why not have boolean type in oracle? Which type can take the place in boolean type?
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.
I prepared to use char(1).
thanks very much.
Click Here to Expand Forum to Full Width