-
why not have boolean type in oracle? Which type can take the place in boolean type?
Please help
thanks
ocean
-
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.
-
thank you
I prepared to use char(1).
thanks very much.
ocean
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|