Re: Boolean datatype in Oracle?
From: Frank van Bortel <fbortel_at_home.nl>
Date: Mon, 20 Nov 2000 20:19:29 GMT
Message-ID: <3A22C203.91062EB1_at_home.nl>
Date: Mon, 20 Nov 2000 20:19:29 GMT
Message-ID: <3A22C203.91062EB1_at_home.nl>
IMHO you don't need one - just compare a column value with a literal;
the outcome is boolean:
Robert Martin wrote:
WHERE <column_name> = <literal>
> What is the best way in an Oracle database to represent a Boolean value for
> a column in a table? I see there is no simple Boolean datatype (which I find
> to be pretty lame IMO). Thanks in advance.
>
> -------------------------------------------
> Robert Martin (rwmartin_at_sisconet.com)
> Design Engineer
> SISCO Inc,
> 6605 19 1/2 Mile Road
> Sterling Heights, MI 48314-1408
> Phone : 810-254-0020 (ext 125)
> Fax : 810-254-0053
-- Gtrz, Frank van BortelReceived on Mon Nov 20 2000 - 21:19:29 CET