Re: Represent boolean

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Sat, 01 Jun 2002 16:13:33 -0700
Message-ID: <3CF9551D.2730EAE0@exesolutions.com>

alex wrote:

> Hi,
> I'm a new user of Oralce. I would like to know how to represent a
> boolean in an Oracle Database. I try BIT, BOOLEAN but it seems not to
> work. Now, I use a SMALLINT but I would like to know if there is a
> specific type to do it.
> Thanks in advance for your help.

This may well stagger the imagination ... but in Oracle ... BOOLEAN is BOOLEAN as in:

DECLARE myVariable BOOLEAN;

If you are talking about a table field ... you can define it any way you want but Boolean is not an option.

Daniel Morgan Received on Sat Jun 01 2002 - 18:13:33 CDT