阅读背景:

如何解决此代码上的错误

来源:互联网 
CREATE TABLE ITEM
(
ITEMCODE CHAR(2) PRIMARY KEY,
ITEMNAME VARCHAR(20) NOT NULL,
UNIT_MEASURE VARCHAR(10) CHECK (UNIT_MEASURE IN ('MTR','KG','TONN','LTR','NOS')),
RATE NUMBER(10,2) CHECK (RATE > 0),
STOCK NUMBER(10,2),
MINSTOCK NUMBER(10,2),
MAXSTOCK NUMBER(10,2),
DRAWINGSP VARCHAR(10) DEFAULT 'DR1000',
CHECK (STORE BETWEEN MINSTOCK AND MAXSTOCK) );
CREATE TABLE ITEM
(
ITEMCODE CHAR(2) PRIMARY KE



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: