Re: type boolean

Thanks i fiugred it out. it is number(0,1) :) Thanks anyways
Najm
"Najm Hashmi" <najmh_at_videotron.ca> wrote in message news:XwAq7.2456$kD6.112984_at_weber.videotron.net...
> Hi, I was just wondering how to declare a boolean field in a table. below
 is
> my table definition could someone help me out here and let me know what is
> equivalent of boolean data type in oracle.
>
> SQL> run
> 1 CREATE TABLE download_logs (
> 2 id integer NOT NULL,
> 3 username character va
> 4 password character va
> 5 usr_ip character vary
> 6 dtime date,
> 7 version character var
> 8 islogedin bool,
> 9 Constraint download_lo
> 10* )
> islogedin bool,
> *
> ERROR at line 8:
> ORA-00902: invalid datatype
>
> Thanks in advance.
> Regards,
> Najm
>
>
Received on Fri Sep 21 2001 - 10:56:02 CEST