所以我剛開始使用 SQL，我有幾行代碼
INSERT All INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID)
VALUES
('V01', 'WILSON', 'SARAH', 'DR', '6122', 'SENIOR PARTNER', '45,000', P1)
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID)
('V02', 'MCDONALD', 'BRYAN', 'DR', '6153', 'SENIOR PARTNER', '35,000', P1)
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID)
('V03', 'PATEL', 'JANE', 'DR', '6165', 'JUNIOR PARTNER', '29,000', P2)
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID)
('V04', 'MCCAFFERTY', 'TREVOR', 'MR', '6166', 'JUNIOR PARTNER', '25,600', P2)
SELECT * FROM dual;
我得到 ORA-00928: 缺少 SELECT 關鍵字錯誤不知道我做錯了什么
uj5u.com熱心網友回復：
您VALUES在某些陳述句中遺漏了關鍵字，如下所示：
INSERT All
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID) VALUES ('V01', 'WILSON', 'SARAH', 'DR', '6122', 'SENIOR PARTNER', '45,000', P1)
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID) VALUES ('V02', 'MCDONALD', 'BRYAN', 'DR', '6153', 'SENIOR PARTNER', '35,000', P1)
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID) VALUES ('V03', 'PATEL', 'JANE', 'DR', '6165', 'JUNIOR PARTNER', '29,000', P2)
INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID) VALUES ('V04', 'MCCAFFERTY', 'TREVOR', 'MR', '6166', 'JUNIOR PARTNER', '25,600', P2)
SELECT * FROM dual;
uj5u.com熱心網友回復：
就像 Farshid 說的那樣，您缺少Values某些陳述句，但是您也可以通過僅用逗號分隔值串列來進一步簡化陳述句，而不是使用一堆插入陳述句
INSERT INTO VET (VET_ID, SURNAME, FORENAME, TITLE, EXT_NUMBER, POSITION, SALARY, PRACTICE_ID)
VALUES
('V01', 'WILSON', 'SARAH', 'DR', '6122', 'SENIOR PARTNER', '45,000', P1),
('V02', 'MCDONALD', 'BRYAN', 'DR', '6153', 'SENIOR PARTNER', '35,000', P1),
('V03', 'PATEL', 'JANE', 'DR', '6165', 'JUNIOR PARTNER', '29,000', P2),
('V04', 'MCCAFFERTY', 'TREVOR', 'MR', '6166', 'JUNIOR PARTNER', '25,600', P2)
SELECT * FROM dual;
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/338953.html
上一篇：SQL中的分組IF陳述句