Re: Boolean data type?

From: Jurij Modic <jmodic_at_src.si>
Date: 1998/09/17
Message-ID: <3600ab06.656844@news.siol.net>#1/1

On Wed, 16 Sep 1998 22:38:08 -0700, "Winnie Liu" <oracle_dba_at_zdnetmail.com> wrote:

>btw, the dbms_job package (the broken function..) ask to imput a boolean
>(broken in boolean).. what should I put? "TRUE","FALSE","T","F","Y","N"
>or....

DBMS_JOB package is PL/SQL structure, not SQL. Datatypes in SQL and PL/SQL differ sometimes (for example LONG). SQL doesn't know about boolean data type, while in PL/SQL boolean is a regular datatype! You can use boolean variables enywhere in PL/SQL.

The allowed values for boolean variables are "TRUE", "FALSE" and "NULL" (without quotes).

>Winnie

HTH,

--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer

Received on Thu Sep 17 1998 - 00:00:00 CDT