DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: why not have boolean type£¿

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    99
    why not have boolean type in oracle? Which type can take the place in boolean type?
    Please help
    thanks
    ocean

  2. #2
    Join Date
    Oct 2001
    Posts
    122

    Wink

    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.



  3. #3
    Join Date
    Sep 2001
    Posts
    99

    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
  •  


Click Here to Expand Forum to Full Width