Re: Booleans

From: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: Sun, 24 Sep 2000 22:29:05 +0100
Message-ID: <8qlo7p$4da$18$1@news.t-online.com>

Hallo Steve!
Your post is correct! The boolean-datatype is only available in PL/SQL!

Stefan.

Steve McDaniels <steve.mcdaniels_at_sierra.com> schrieb in im Newsbeitrag: 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 Sun Sep 24 2000 - 16:29:05 CDT