Re: Booleans

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Mon, 25 Sep 2000 08:34:29 +0200
Message-ID: <#XTjgrrJAHA.346@net025s>

This next statement however, works fine......

  1 create or replace function test_boolean return varchar2   2 as
  3 loc_var boolean;
  4 loc_date date;
  5 begin
  6 loc_var := TRUE;
  7 if loc_var then

  8      select sysdate
  9      into   loc_date
 10      from   dual;
 11      return('TRUE');
 12    else
 13      return('FALSE');

 14 end if;
 15* end test_boolean;
SQL> / Function created.

SQL> select sysdate
  2 from dual
  3 where test_boolean = 'TRUE';

So there is a datatype called boolean in PL/SQL, just not available for DDL. So for DDL use a varchar2(1) with an attached domain ('Y','N').

But thanks for the additional info :-)

Steve McDaniels <steve.mcdaniels_at_sierra.com> wrote in message news:8qlmqa$l86$1_at_spiney.sierra.com...
> SQL> create table test
> 2 (key number,
> 3 junk boolean);
> junk boolean)
> *
> ERROR at line 3:
> ORA-00902: invalid datatype
>
> on Oracle 8.0.6.
>
> er, ah, gee, maybe I'm misspelling it.
>
> "Reinier" <Reinier_Dickhout_at_hetnet.nl> wrote in message
> news:#p$6yT5IAHA.178_at_net025s...
> > Try BOOLEAN ;-)
> >
> > Reinier.
> >
> > Sandro PIAZZINI <sandro.piazzini_at_programmer.net> wrote in message
> > news:8qaqj4$7gq$1_at_news6.isdnet.net...
> > > Hello,
> > >
> > > What is the best datatype to treat Booleans (like Yes/No fields)
> > >
> > >
> >
> >
>
>
Received on Mon Sep 25 2000 - 01:34:29 CDT