我有一个插入语句，但有一个逗号错误，我只是无法修复它

Question

这是我必须做的代码，但它给出了一个错误，说代码没有正确结束，我看不出问题，也许我只是瞎了，但我不知道。

INSERT INTO Customer VALUES
(11011, 'Jeffery', 'Smith', '18 Water RD', 0877277521, '[e-mail]'),(its giving me an error here and saying the statement hasn't ended correctly)
(11012, 'Alex', 'Hendricks', '22 Water Rd', 0863257857 , '[e-mail]'),
(11013 , 'Johnson', 'Clark', '101 Summer Lane', 0834567891,'[e-mail]'),
(11014 , 'Henry', 'Jones', '55 Mountain Way',0612547895 ,'[e-mail]'),
(11015 , 'Andre', 'Williams', '5 Main Rd ', 0827238521,'[e-mail]');

Answer 1

Oracle一次只支持在行上插入。最简单的解决方案是多个插入：

INSERT INTO Customer VALUES (11011, 'Jeffery', 'Smith', '18 Water RD', 0877277521, '[e-mail]');
INSERT INTO Customer VALUES (11012, 'Alex', 'Hendricks', '22 Water Rd', 0863257857 , '[e-mail]');
INSERT INTO Customer VALUES (11013 , 'Johnson', 'Clark', '101 Summer Lane', 0834567891,'[e-mail]');
INSERT INTO Customer VALUES (11014 , 'Henry', 'Jones', '55 Mountain Way',0612547895 ,'[e-mail]');
INSERT INTO Customer VALUES (11015 , 'Andre', 'Williams', '5 Main Rd ', 0827238521,'[e-mail]');

其他解决方案是使用insert all或将语句从values转换为select . . . from dual union all。

我还建议您明确列出列，以帮助防止无意的错误。

Answer 2

您可以使用INSERT ALL语句

INSERT ALL
INTO Customer VALUES (11011, 'Jeffery', 'Smith', '18 Water RD', 0877277521, '[e-mail]')
INTO Customer VALUES (11012, 'Alex', 'Hendricks', '22 Water Rd', 0863257857 , '[e-mail]')
INTO Customer VALUES (11013 , 'Johnson', 'Clark', '101 Summer Lane', 0834567891,'[e-mail]')
INTO Customer VALUES (11014 , 'Henry', 'Jones', '55 Mountain Way',0612547895 ,'[e-mail]')
INTO Customer VALUES (11015 , 'Andre', 'Williams', '5 Main Rd ', 0827238521,'[e-mail]')
SELECT * FROM DUAL;

db<gt；在这里摆弄