SQL 错误 [933] [42000]: ORA-00933: SQL 命令未正确结束-CSDN博客

本文链接：https://blog.csdn.net/taibaishenlong/article/details/117331469

本文讲述了使用DBeaver向Oracle数据库插入大量相同数据时遇到的错误，通过将INSERT语句改为INSERT ALL解决了批量插入问题。关键步骤包括修改SQL代码并演示了如何避免重复记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、报错背景：使用DBeaver向oracle插入大量数据，数据如下：

INSERT  INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
;
INSERT  INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
,('Nike','男','18','北京','2000-01-01')
,('Nike','女','18','北京','2000-01-01')
;

2、点击执行SQL脚本(Alt+X) :出现如下内容：

3、解决改批量删除问题，修改sql代码如下：


INSERT ALL INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','女','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','女','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','女','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','女','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','男','18','北京','2000-01-01')
INTO Student(name,sex,age,address,birthday) VALUES('Nike','女','18','北京','2000-01-01')
SELECT 1 FROM dual

4、再次执行SQL脚本(Alt+X)，即可添加成功。

希望对大家有所帮助，前路漫漫，一起探究.........................