Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can't figure out why this has an error?

Can't figure out why this has an error?

From: Vishal <vabru4u_at_yahoo.com>
Date: 4 Mar 2004 23:51:21 -0800
Message-ID: <3fc78ae.0403042351.79b28eac@posting.google.com>


create table ITEMS
(
ITEMID number constraint ITEM_PK primary key, ITEMDESC varchar2(300),
ICAT number constraint FK_ITEM_CAT references CATEGORY, PRICE number(9,2) constraint PRICE_CHECK check (price not null and price > 10),

SOLD char(1) constraint check (sold not null and sold in ('Y', 'N')

);

I get the following error:

PRICE number(9,2) constraint PRICE_CHECK check (price not null and price > 10),

                                                          *
ERROR at line 6:
ORA-00920: invalid relational operator

Any ideas? Thanks! Received on Fri Mar 05 2004 - 01:51:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US