Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 17 2007
Added on Aug 20 2007
3 comments
1,610 views