Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Booleans

Re: Booleans

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Sun, 24 Sep 2000 13:06:17 -0700
Message-ID: <8qlmqa$l86$1@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 - 15:06:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US