Re: Booleans

standard practice over boolean true or false, exactly for the reasons the original poster mentioned: there's no boolean in sql, so you can't test in sql. Don't think there's a performance issue, either.

Gtrz, Frank

Niall Litchfield wrote:

> Does no-one else use a number datatype with zero and one as permitted
> values.
> "Reinier" <Reinier_Dickhout_at_hetnet.nl> wrote in message
> news:#XTjgrrJAHA.346_at_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 Wed Sep 27 2000 - 13:50:45 CDT