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>

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