Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: boolean types and portability

Re: boolean types and portability

From: damorgan <damorgan_at_exesolutions.com>
Date: Fri, 22 Mar 2002 17:20:17 GMT
Message-ID: <3C9B67D4.3DEA46CB@exesolutions.com>


INT and SMALLINT are just subtypes of NUMBER. Just use NUMBER(1).

Daniel Morgan

Neil Zanella wrote:

> Hello,
>
> I would like to know what the most portable way of
> implementing a table with boolean values is in Oracle
> as it does not have a BOOL or BOOLEAN type and it seems
> like INT or SMALLINT or similar must be used instead.
>
> Thanks,
>
> Neil
Received on Fri Mar 22 2002 - 11:20:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US