create table orderitem
(
ORDERITEMID NUMBER(11) NOT NULL,
BOOK_ID NUMBER(11) NOT NULL,
PRICE NUMBER(11,2) NOT NULL,
NUM NUMBER(11) DEFAULT 1 NOT NULL,
ORDER_ID NUMBER(11) NOT NULL
);
ALTER TABLE ORDERITEM ADD CONSTRAINT orderitem_type_pk PRIMARY KEY (ORDERITEM);
commit
先运行建表,然后在运行建主键,然后报错说 ORDERITEM标示符无效,我真的不知道我哪错了
(
ORDERITEMID NUMBER(11) NOT NULL,
BOOK_ID NUMBER(11) NOT NULL,
PRICE NUMBER(11,2) NOT NULL,
NUM NUMBER(11) DEFAULT 1 NOT NULL,
ORDER_ID NUMBER(11) NOT NULL
);
ALTER TABLE ORDERITEM ADD CONSTRAINT orderitem_type_pk PRIMARY KEY (ORDERITEM);
commit
先运行建表,然后在运行建主键,然后报错说 ORDERITEM标示符无效,我真的不知道我哪错了
(
ORDERITEMID NUMBER(11) NOT NULL,
BOOK_ID NUMBER(11) NOT NULL,
PRICE NUMBER(11,2) NOT NULL,
NUM NUMBER(11) DEFAULT 1 NOT NULL,
ORDER_ID NUMBER(11) NOT NULL
);
ALTER TABLE ORDERITEM ADD CONSTRAINT orderitem_type_pk PRIMARY KEY (ORDERITEM);