Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Can't figure out why this has an error?
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:
Any ideas? Thanks! Received on Fri Mar 05 2004 - 01:51:21 CST
![]() |
![]() |