invalid boolean datatype when creating a table
579235Aug 20 2007 — edited Aug 20 2007 hii,
I am trying to create a table with columns as name, autogenerated id, and another column with boolean datatype. but it gives error.
1 create table cust_id
2* ( name varchar(30), id number, allposts BOOLEAN)
SQL> /
( name varchar(30), id number, allposts BOOLEAN)
*
ERROR at line 2:
ORA-00902: invalid datatype.
plz help