问INSERT INTO在SQL Fiddle上失败
EN

Stack Overflow用户

提问于 2019-07-16 03:09:59

回答 1查看 90关注 0票数 1

我正在尝试创建一个用于创建测试数据库的SQL Fiddle。

我的问题如下：

-- schema
CREATE TABLE tblInputs (
    Type VARCHAR(256),
    Order_No VARCHAR(256),
    Planned_No VARCHAR(256),
    Purchase_No VARCHAR(256),
    Direction VARCHAR(256)
);

CREATE TABLE Requirements (
    Order_No VARCHAR(256),
    Planned_No VARCHAR(256),
    Req_ID VARCHAR(256),
    Req_No VARCHAR(256)
);

CREATE TABLE ReqRep (
    Req_ID VARCHAR(256),
    Req_No VARCHAR(256),
    Rep_ID VARCHAR(256)
);

CREATE TABLE Replenishments (
    Rep_ID VARCHAR(256),
    Order_No VARCHAR(256),
    Planned_No VARCHAR(256),
    Purchase_No VARCHAR(256)
);


-- data
INSERT INTO tblInputs (Type, Direction, Order_No, Planned_No, Purchase_No)

SELECT 'Purchase', NULL, NULL, 'PO9000124798', 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908851', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908852', NULL, 'PLUS' FROM DUAL 
UNION ALL
SELECT 'Planned', NULL, 'PL191908853', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908854', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908855', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908853', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Build', 'O103916639', NULL, NULL, 'MIN' FROM DUAL
UNION ALL
SELECT 'Production', 'O103962037', NULL, NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Production', 'O103933200', NULL, NULL, 'PLUS' FROM DUAL

INSERT INTO Requirements (Order_No, Planned_No, Req_ID, Req_No)
SELECT NULL, 'PL191908851', 'ABA', '36' FROM DUAL UNION ALL
SELECT NULL, 'PL191908852', 'CC',  '93' FROM DUAL UNION ALL
SELECT NULL, 'PL191908853', 'BBA', '27' FROM DUAL UNION ALL
SELECT NULL, 'PL191908854', 'EWE', '42' FROM DUAL UNION ALL
SELECT NULL, 'PL191908855', 'WWW', '13' FROM DUAL UNION ALL
SELECT NULL, 'PL191908856', 'EEE', '33' FROM DUAL UNION ALL
SELECT NULL, 'PL191909922', 'GFW', '99' FROM DUAL UNION ALL
SELECT NULL, 'PL191910022', 'GFT', '23' FROM DUAL UNION ALL
SELECT NULL, 'PL192010120', 'THE', '54' FROM DUAL UNION ALL
SELECT 'O103962037',  NULL, 'BDD', '37' FROM DUAL UNION ALL
SELECT 'O103933200',  NULL, 'DFA', '63' FROM DUAL UNION ALL
SELECT 'O103547812',  NULL, 'ADS', '45' FROM DUAL UNION ALL
SELECT 'O103547415',  NULL, 'DWQ', '94' FROM DUAL UNION ALL
SELECT 'O103654787',  NULL, 'QZX', '96' FROM DUAL UNION ALL
SELECT 'O103214217',  NULL, 'NFD', '20' FROM DUAL UNION ALL
SELECT 'O103215320',  NULL, 'GBV', '33' FROM DUAL UNION ALL
SELECT 'O106212219',  NULL, 'ERQ', '22' FROM DUAL UNION ALL
SELECT 'O103215320',  NULL, 'MRP', '11' FROM DUAL

INSERT INTO ReqRep (Req_ID, Req_No, Repl_ID)
SELECT 'ABA', '36', '7736' FROM DUAL UNION ALL
SELECT 'CCC', '93', '6686' FROM DUAL UNION ALL
SELECT 'BBA', '27', '5710' FROM DUAL UNION ALL
SELECT 'EWE', '42', '7634' FROM DUAL UNION ALL
SELECT 'WWW', '13', '9393' FROM DUAL UNION ALL
SELECT 'EEE', '33', '8442' FROM DUAL UNION ALL
SELECT 'GFW', '99', '5758' FROM DUAL UNION ALL
SELECT 'GFT', '23', '5988' FROM DUAL UNION ALL
SELECT 'THE', '54', '6748' FROM DUAL UNION ALL
SELECT 'BDD', '37', '7123' FROM DUAL UNION ALL
SELECT 'BDD', '37', '7124' FROM DUAL UNION ALL
SELECT 'BDD', '37', '7125' FROM DUAL UNION ALL
SELECT 'BDD', '37', '7126' FROM DUAL UNION ALL
SELECT 'DFA', '63', '7125' FROM DUAL UNION ALL
SELECT 'ADS', '45', '5855' FROM DUAL UNION ALL
SELECT 'DWQ', '80', '9419' FROM DUAL UNION ALL
SELECT 'QZX', '96', '5748' FROM DUAL UNION ALL
SELECT 'NFD', '20', '7055' FROM DUAL UNION ALL
SELECT 'ERQ', '22', '7736' FROM DUAL UNION ALL
SELECT 'MRP', '11', '7736' FROM DUAL UNION ALL
SELECT 'GBV', '33', '9999' FROM DUAL

INSERT INTO Replenishments(Rep_ID, Order_No, Planned_No, Purchase_No)
SELECT '7736', NULL, NULL, 'PO9000124799' FROM DUAL UNION ALL
SELECT '6686', NULL, NULL, 'PO9000124800' FROM DUAL UNION ALL
SELECT '5710', NULL, NULL, 'PO9000124801' FROM DUAL UNION ALL
SELECT '7634', NULL, NULL, 'PO9000124802' FROM DUAL UNION ALL
SELECT '9393', NULL, NULL, 'PO9000124803' FROM DUAL UNION ALL
SELECT '8442', NULL, NULL, 'PO9000124804' FROM DUAL UNION ALL
SELECT '5758', NULL, NULL, 'PO9000124805' FROM DUAL UNION ALL
SELECT '5988', NULL, NULL, 'PO9000124806' FROM DUAL UNION ALL
SELECT '6748', NULL, NULL, 'PO9000124807' FROM DUAL UNION ALL
SELECT '7123', 'O103654787', NULL, NULL FROM DUAL UNION ALL
SELECT '7124', 'O103214217', NULL, NULL FROM DUAL UNION ALL
SELECT '7125', 'O103215320', NULL, NULL FROM DUAL UNION ALL
SELECT '7126', 'O106212219', NULL, NULL FROM DUAL UNION ALL
SELECT '7125', 'O103215320', NULL, NULL FROM DUAL UNION ALL
SELECT '5855', NULL, 'PL192010120', NULL FROM DUAL UNION ALL
SELECT '9419', NULL, 'PL121122221', NULL FROM DUAL UNION ALL
SELECT '5748', NULL, 'PL272634123', NULL FROM DUAL UNION ALL
SELECT '7055', NULL, 'PL983002032', NULL FROM DUAL UNION ALL
SELECT '9999', NULL, NULL, 'PO9000124806' FROM DUAL UNION ALL
SELECT '1111', NULL, NULL, 'PO9000124806' FROM DUAL

然而，我得到了一个错误：

SQL 00933：

命令未正确结束

我只是想创建几个表，以便在以后的SO post中使用。到目前为止，查询已成功运行：

-- schema
CREATE TABLE tblInputs (
    Type VARCHAR(256),
    Order_No VARCHAR(256),
    Planned_No VARCHAR(256),
    Purchase_No VARCHAR(256),
    Direction VARCHAR(256)
);

CREATE TABLE Requirements (
    Order_No VARCHAR(256),
    Planned_No VARCHAR(256),
    Req_ID VARCHAR(256),
    Req_No VARCHAR(256)
);

CREATE TABLE ReqRep (
    Req_ID VARCHAR(256),
    Req_No VARCHAR(256),
    Rep_ID VARCHAR(256)
);

CREATE TABLE Replenishments (
    Rep_ID VARCHAR(256),
    Order_No VARCHAR(256),
    Planned_No VARCHAR(256),
    Purchase_No VARCHAR(256)
);


-- data
INSERT INTO tblInputs (Type, Direction, Order_No, Planned_No, Purchase_No)

SELECT 'Purchase', NULL, NULL, 'PO9000124798', 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908851', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908852', NULL, 'PLUS' FROM DUAL 
UNION ALL
SELECT 'Planned', NULL, 'PL191908853', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908854', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908855', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Planned', NULL, 'PL191908853', NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Build', 'O103916639', NULL, NULL, 'MIN' FROM DUAL
UNION ALL
SELECT 'Production', 'O103962037', NULL, NULL, 'PLUS' FROM DUAL
UNION ALL
SELECT 'Production', 'O103933200', NULL, NULL, 'PLUS' FROM DUAL

它在第二个INSERT INTO语句上失败。

我已经检查了this post和this post，但找不到解决方案。

sql

oracle

oracle11g

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-07-16 03:12:50

每个查询都需要使用分号

    INSERT INTO tblInputs (Type, Direction, Order_No, Planned_No, Purchase_No)

    SELECT 'Purchase', NULL, NULL, 'PO9000124798', 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Planned', NULL, 'PL191908851', NULL, 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Planned', NULL, 'PL191908852', NULL, 'PLUS' FROM DUAL 
    UNION ALL
    SELECT 'Planned', NULL, 'PL191908853', NULL, 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Planned', NULL, 'PL191908854', NULL, 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Planned', NULL, 'PL191908855', NULL, 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Planned', NULL, 'PL191908853', NULL, 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Build', 'O103916639', NULL, NULL, 'MIN' FROM DUAL
    UNION ALL
    SELECT 'Production', 'O103962037', NULL, NULL, 'PLUS' FROM DUAL
    UNION ALL
    SELECT 'Production', 'O103933200', NULL, NULL, 'PLUS' FROM DUAL7
    -- here
    ;


    INSERT INTO Requirements (Order_No, Planned_No, Req_ID, Req_No)
    SELECT NULL, 'PL191908851', 'ABA', '36' FROM DUAL UNION ALL
    SELECT NULL, 'PL191908852', 'CC',  '93' FROM DUAL UNION ALL
    SELECT NULL, 'PL191908853', 'BBA', '27' FROM DUAL UNION ALL
    SELECT NULL, 'PL191908854', 'EWE', '42' FROM DUAL UNION ALL
    SELECT NULL, 'PL191908855', 'WWW', '13' FROM DUAL UNION ALL
    SELECT NULL, 'PL191908856', 'EEE', '33' FROM DUAL UNION ALL
    SELECT NULL, 'PL191909922', 'GFW', '99' FROM DUAL UNION ALL
    SELECT NULL, 'PL191910022', 'GFT', '23' FROM DUAL UNION ALL
    SELECT NULL, 'PL192010120', 'THE', '54' FROM DUAL UNION ALL
    SELECT 'O103962037',  NULL, 'BDD', '37' FROM DUAL UNION ALL
    SELECT 'O103933200',  NULL, 'DFA', '63' FROM DUAL UNION ALL
    SELECT 'O103547812',  NULL, 'ADS', '45' FROM DUAL UNION ALL
    SELECT 'O103547415',  NULL, 'DWQ', '94' FROM DUAL UNION ALL
    SELECT 'O103654787',  NULL, 'QZX', '96' FROM DUAL UNION ALL
    SELECT 'O103214217',  NULL, 'NFD', '20' FROM DUAL UNION ALL
    SELECT 'O103215320',  NULL, 'GBV', '33' FROM DUAL UNION ALL
    SELECT 'O106212219',  NULL, 'ERQ', '22' FROM DUAL UNION ALL
    SELECT 'O103215320',  NULL, 'MRP', '11' FROM DUAL
    -- here
    ;


    INSERT INTO ReqRep (Req_ID, Req_No, Repl_ID)
    SELECT 'ABA', '36', '7736' FROM DUAL UNION ALL
    SELECT 'CCC', '93', '6686' FROM DUAL UNION ALL
    SELECT 'BBA', '27', '5710' FROM DUAL UNION ALL
    SELECT 'EWE', '42', '7634' FROM DUAL UNION ALL
    SELECT 'WWW', '13', '9393' FROM DUAL UNION ALL
    SELECT 'EEE', '33', '8442' FROM DUAL UNION ALL
    SELECT 'GFW', '99', '5758' FROM DUAL UNION ALL
    SELECT 'GFT', '23', '5988' FROM DUAL UNION ALL
    SELECT 'THE', '54', '6748' FROM DUAL UNION ALL
    SELECT 'BDD', '37', '7123' FROM DUAL UNION ALL
    SELECT 'BDD', '37', '7124' FROM DUAL UNION ALL
    SELECT 'BDD', '37', '7125' FROM DUAL UNION ALL
    SELECT 'BDD', '37', '7126' FROM DUAL UNION ALL
    SELECT 'DFA', '63', '7125' FROM DUAL UNION ALL
    SELECT 'ADS', '45', '5855' FROM DUAL UNION ALL
    SELECT 'DWQ', '80', '9419' FROM DUAL UNION ALL
    SELECT 'QZX', '96', '5748' FROM DUAL UNION ALL
    SELECT 'NFD', '20', '7055' FROM DUAL UNION ALL
    SELECT 'ERQ', '22', '7736' FROM DUAL UNION ALL
    SELECT 'MRP', '11', '7736' FROM DUAL UNION ALL
    SELECT 'GBV', '33', '9999' FROM DUAL
    -- here
    ;


    INSERT INTO Replenishments(Rep_ID, Order_No, Planned_No, Purchase_No)
    SELECT '7736', NULL, NULL, 'PO9000124799' FROM DUAL UNION ALL
    SELECT '6686', NULL, NULL, 'PO9000124800' FROM DUAL UNION ALL
    SELECT '5710', NULL, NULL, 'PO9000124801' FROM DUAL UNION ALL
    SELECT '7634', NULL, NULL, 'PO9000124802' FROM DUAL UNION ALL
    SELECT '9393', NULL, NULL, 'PO9000124803' FROM DUAL UNION ALL
    SELECT '8442', NULL, NULL, 'PO9000124804' FROM DUAL UNION ALL
    SELECT '5758', NULL, NULL, 'PO9000124805' FROM DUAL UNION ALL
    SELECT '5988', NULL, NULL, 'PO9000124806' FROM DUAL UNION ALL
    SELECT '6748', NULL, NULL, 'PO9000124807' FROM DUAL UNION ALL
    SELECT '7123', 'O103654787', NULL, NULL FROM DUAL UNION ALL
    SELECT '7124', 'O103214217', NULL, NULL FROM DUAL UNION ALL
    SELECT '7125', 'O103215320', NULL, NULL FROM DUAL UNION ALL
    SELECT '7126', 'O106212219', NULL, NULL FROM DUAL UNION ALL
    SELECT '7125', 'O103215320', NULL, NULL FROM DUAL UNION ALL
    SELECT '5855', NULL, 'PL192010120', NULL FROM DUAL UNION ALL
    SELECT '9419', NULL, 'PL121122221', NULL FROM DUAL UNION ALL
    SELECT '5748', NULL, 'PL272634123', NULL FROM DUAL UNION ALL
    SELECT '7055', NULL, 'PL983002032', NULL FROM DUAL UNION ALL
    SELECT '9999', NULL, NULL, 'PO9000124806' FROM DUAL UNION ALL
    SELECT '1111', NULL, NULL, 'PO9000124806' FROM DUAL
    -- here
    ;

票数 4

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/57045846

复制

相似问题

问INSERT INTO在SQL Fiddle上失败
EN

回答 1

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问INSERT INTO在SQL Fiddle上失败EN

回答 1

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问INSERT INTO在SQL Fiddle上失败
EN