ORA-00928:当我尝试在Oracle数据库表中插入多个行时,缺少选择关键字

发布于 2025-02-14 02:06:31 字数 919 浏览 0 评论 0原文

我正在尝试在Oracle表中插入多行,但是获取以下错误

ORA-00928: missing SELECT keyword 

是我的插入语句

INSERT ALL
      into COUNTRY ("CountryID","CountryName") values (1,'Germany')
      into COUNTRY ("CountryID","CountryName") values (2,'United Kingdom')
      into COUNTRY ("CountryID","CountryName") values (3,'United States')
      into COUNTRY ("CountryID","CountryName") values (4,'Russia')
      into COUNTRY ("CountryID","CountryName") values (5,'France')
      into COUNTRY ("CountryID","CountryName") values (6,'Pakistan')
      into COUNTRY ("CountryID","CountryName") values (7,'India')
      into COUNTRY ("CountryID","CountryName") values (8,'Brazil')
      into COUNTRY ("CountryID","CountryName") values (9,'Itly')
      into COUNTRY ("CountryID","CountryName") values (10,'Iran'),
      into COUNTRY ("CountryID","CountryName") values (11,'Austria')
SELECT 1 FROM DUAL;

I am trying to insert multiple rows in the oracle table but getting the following error

ORA-00928: missing SELECT keyword 

Following are my insert statements

INSERT ALL
      into COUNTRY ("CountryID","CountryName") values (1,'Germany')
      into COUNTRY ("CountryID","CountryName") values (2,'United Kingdom')
      into COUNTRY ("CountryID","CountryName") values (3,'United States')
      into COUNTRY ("CountryID","CountryName") values (4,'Russia')
      into COUNTRY ("CountryID","CountryName") values (5,'France')
      into COUNTRY ("CountryID","CountryName") values (6,'Pakistan')
      into COUNTRY ("CountryID","CountryName") values (7,'India')
      into COUNTRY ("CountryID","CountryName") values (8,'Brazil')
      into COUNTRY ("CountryID","CountryName") values (9,'Itly')
      into COUNTRY ("CountryID","CountryName") values (10,'Iran'),
      into COUNTRY ("CountryID","CountryName") values (11,'Austria')
SELECT 1 FROM DUAL;

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

笑脸一如从前 2025-02-21 02:06:31

删除了一个“昏迷”:

INSERT ALL
      into COUNTRY ("CountryID","CountryName") values (1,'Germany')
      into COUNTRY ("CountryID","CountryName") values (2,'United Kingdom')
      into COUNTRY ("CountryID","CountryName") values (3,'United States')
      into COUNTRY ("CountryID","CountryName") values (4,'Russia')
      into COUNTRY ("CountryID","CountryName") values (5,'France')
      into COUNTRY ("CountryID","CountryName") values (6,'Pakistan')
      into COUNTRY ("CountryID","CountryName") values (7,'India')
      into COUNTRY ("CountryID","CountryName") values (8,'Brazil')
      into COUNTRY ("CountryID","CountryName") values (9,'Itly')
      into COUNTRY ("CountryID","CountryName") values (10,'Iran')
      into COUNTRY ("CountryID","CountryName") values (11,'Austria')
SELECT 1 FROM DUAL;

Deleted one "coma":

INSERT ALL
      into COUNTRY ("CountryID","CountryName") values (1,'Germany')
      into COUNTRY ("CountryID","CountryName") values (2,'United Kingdom')
      into COUNTRY ("CountryID","CountryName") values (3,'United States')
      into COUNTRY ("CountryID","CountryName") values (4,'Russia')
      into COUNTRY ("CountryID","CountryName") values (5,'France')
      into COUNTRY ("CountryID","CountryName") values (6,'Pakistan')
      into COUNTRY ("CountryID","CountryName") values (7,'India')
      into COUNTRY ("CountryID","CountryName") values (8,'Brazil')
      into COUNTRY ("CountryID","CountryName") values (9,'Itly')
      into COUNTRY ("CountryID","CountryName") values (10,'Iran')
      into COUNTRY ("CountryID","CountryName") values (11,'Austria')
SELECT 1 FROM DUAL;
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文