Re: Lack of support for logical variables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 29 Jan 2006 06:59:08 +0100
Message-ID: <bamot1dcj6hro3j8ecflb8oj2qhjahrtnl@4ax.com>

On Sun, 29 Jan 2006 07:46:58 +0330, "Michael Cello" <mike1210000_at_yahoo.com> wrote:

>Thank you for your response. By logical variable, I mean a field with 'true'
>and 'false' contents. Our existing programs use logical variables and my
>efforts are to translate these programs to be used with Oracle without
>having to re-write the whole system due to the bulk volume of programs.
>Please advise.
>

They don't exist in SQL, but do exist in PL/SQL. The convention is to use VARCHAR2(1) columns which are either 'Y' or 'N'.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Jan 28 2006 - 23:59:08 CST