oracle怎么一下插入两条以上数据，为什么我会提示错误

答案:4 悬赏:80 手机版

解决时间 2021-04-04 10:03

提问者网友：做自己de王妃
2021-04-03 21:45

INSERT INTO EMPLOYEES (EMPID,EMPNAME) VALUES(USER_S.NEXTVAL,'Employee1');
INSERT INTO EMPLOYEES (EMPID,EMPNAME) VALUES(USER_S.NEXTVAL,'Employee2');
INSERT INTO EMPLOYEES (EMPID,EMPNAME) VALUES(USER_S.NEXTVAL,'Employee3');
COMMIT;

ORA-00911: 无效字符

最佳答案

五星知识达人网友：鸽屿
2020-01-29 16:18

因为一次只执行一条语句。你要写成语句快才行。
试试这样行不行:
begin
INSERT INTO EMPLOYEES (EMPID,EMPNAME) VALUES(USER_S.NEXTVAL,'Employee1');
INSERT INTO EMPLOYEES (EMPID,EMPNAME) VALUES(USER_S.NEXTVAL,'Employee2');
INSERT INTO EMPLOYEES (EMPID,EMPNAME) VALUES(USER_S.NEXTVAL,'Employee3');
COMMIT;
end;

全部回答

1楼网友：由着我着迷
2021-03-15 12:17

VALUES改成VALUE

2楼网友：一把行者刀
2019-11-24 13:25

取序列的值需要用SELECt语句才行比如 INSERT INTO EMPLOYEES (EMPID,EMPNAME) SELECT USER_S.NEXTVAL,'Employee1' FROM DUAL; INSERT INTO EMPLOYEES (EMPID,EMPNAME) SELECt USER_S.NEXTVAL,'Employee2' FROM DUAL; INSERT INTO EMPLOYEES (EMPID,EMPNAME) SELECt USER_S.NEXTVAL,'Employee3' FROM DUAL; COMMIT;

3楼网友：人间朝暮
2020-06-17 11:59

INSERT INTO EMPLOYEES (EMPID,EMPNAME) select USER_S.NEXTVAL,a.* from ( select 'Employee1' from dual union select 'Employee2' from dual union select 'Employee3' from dual ) a ; COMMIT; 试试这个

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息