type boolean
From: Najm Hashmi <najmh_at_videotron.ca>
Date: Fri, 21 Sep 2001 01:48:27 -0700
Message-ID: <XwAq7.2456$kD6.112984_at_weber.videotron.net>
ERROR at line 8:
ORA-00902: invalid datatype
Date: Fri, 21 Sep 2001 01:48:27 -0700
Message-ID: <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:48:27 CEST