Oracle执行以下程序报错：这段程序报错ora-00904，请问下啥原因
0
CREATE TABLE TEMP_C1
( TC_ID NUMBER,
TC_SALARY NUMBER,
)
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(1,1000),
VALUES(2,1500),
VALUES(3,1650),
VALUES(4,1000),
VALUES(5,1500),
VALUES(6,2000),
VALUES(7,3500),
VALUES(8,4800);
( TC_ID NUMBER,
TC_SALARY NUMBER,
)
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(1,1000),
VALUES(2,1500),
VALUES(3,1650),
VALUES(4,1000),
VALUES(5,1500),
VALUES(6,2000),
VALUES(7,3500),
VALUES(8,4800);
没有找到相关结果
重要提示：提问者不能发表回复，可以通过评论与回答者沟通，沟通后可以通过编辑功能完善问题描述，以便后续其他人能够更容易理解问题.
1 个回复
老头子 - 专注是唯一的捷径 2015-10-16 回答
赞同来自:
( TC_ID NUMBER,
TC_SALARY NUMBER,
)
多一个逗号
改成
CREATE TABLE TEMP_C1
( TC_ID NUMBER,
TC_SALARY NUMBER
)
而且你的create table少了分号，insert语句也写错了，正确的如下：
CREATE TABLE TEMP_C1
( TC_ID NUMBER,
TC_SALARY NUMBER
)
;
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(1,1000);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(2,1500);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(3,1650);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(4,1000);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(5,1500);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(6,2000);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(7,3500);
INSERT INTO TEMP_C1(TC_ID,TC_SALARY)
VALUES(8,4800);
commit;