Re: Represent boolean

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 02 Jun 2002 17:10:27 GMT
Message-ID: <7ksK8.42728$0A2.33959@rwcrnsc54>

Because if you read the documentation you will find that there is no Boolean data type for a table. So Daniel was telling you exactly that - in Oracle you cannot have a field type that is Boolean. In addition, the error you are getting from Oracle is telling you you cannot have a Boolean data type as a field.

You can make a field that only allows 0 and 1 as a number if you want. Jim

"alex" <alienhipopotamus_at_caramail.com> wrote in message news:1d3c465f.0206020900.60e55b36_at_posting.google.com...
> > If you are talking about a table field ... you can define it any way you
> > want but Boolean is not an option.
>
> I have try this SQL command:
> CREATE TABLE TEST (myvar BOOLEAN);
> Oracle responde this:
> ORA-00902: invalid datatype
> Why can't I use BOOLEAN here?
> Thanks.
Received on Sun Jun 02 2002 - 12:10:27 CDT