why not have boolean type in oracle? Which type can take the place in boolean type?
Please help
thanks
Printable View
why not have boolean type in oracle? Which type can take the place in boolean type?
Please help
thanks
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.