sql - 多个 INSERT INTO 语句在 dbeaver 中不起作用

Question

我正在尝试将数据插入表中，并且我已经编写了多个 Insert Into 语句，但我遇到了一个非常奇怪的问题。当我运行整个脚本时，它会在分号之前的语句末尾给出错误字符，但是当我单独运行每个语句时它工作正常。有数千行要添加，我无法单独执行所有行。有什么想法吗？

表结构:

CREATE TABLE "MFR"."NEWTABLE" 
   (    "NAME" VARCHAR2(100 CHAR), 
    "Registry_ID" VARCHAR2(100 CHAR), 
    "MFR_TYPE" VARCHAR2(100 CHAR), 
    "LIFECYCLE_PHASE" VARCHAR2(100 CHAR), 
    "ADDRESS" VARCHAR2(100 CHAR), 
    "CITY" VARCHAR2(100 CHAR), 
    "MANU_STATE" VARCHAR2(100 CHAR), 
    "MANU_COUNTRY" VARCHAR2(100 CHAR), 
    "POSTAL_CODE" VARCHAR2(100 CHAR), 
    "PHONE" VARCHAR2(100 CHAR), 
    "MANUFACTURER_LEGAL_NAME" VARCHAR2(100 CHAR), 
    "ORIGINATOR" VARCHAR2(100 CHAR), 
    "SUPPLIERMFR_ID" VARCHAR2(100 CHAR), 
    "SE_MANUFACTURER_NAME" VARCHAR2(100 CHAR), 
    "SE_MANUFACTURER_OLD_NAME_1" VARCHAR2(100 CHAR), 
    "SE_MANUFACTURER_OLD_NAME_2" VARCHAR2(100 CHAR), 
    "SE_MANUFACTURER_OLD_NAME_3" VARCHAR2(100 CHAR), 
    "SE_MANUFACTURER_OLD_NAME_4" VARCHAR2(100 CHAR), 
    "SE_MANUFACTURER_OLD_NAME_5" VARCHAR2(100 CHAR)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "SYSTEM" ;

示例插入语句:

INSERT INTO NEWTABLE VALUES ('PESSIL DEVELOPMENT LIMITED','3008','Manufacturer','Approved','Hopewell Industrial city ,Sima,Changping','Dongguan',NULL,NULL,'N/A','86-769-3391096','PESSIL DEVELOPMENT LIMITED','Julia Yang','PP13630',NULL,NULL,NULL,NULL,NULL,NULL); 
INSERT INTO NEWTABLE VALUES ('MING TONG','3013','Manufacturer','Approved','No. 10 Yang Shi Metal Sueface processing Industrial Park ,','Wu Xi',NULL,NULL,'214154','0136-5617-8698','MING TONG BIAU SHENG CO.,LTD','Jamie Wang','SS01111',NULL,NULL,NULL,NULL,NULL,NULL); 
INSERT INTO NEWTABLE VALUES ('LI TENG ENTERPRISE CO LTD','3012','Manufacturer','Approved','No. 49-22, 5 Lin, Tai-Ho-Tsuen','Ju-Bai',NULL,NULL,'302','N/A','LI TENG ENTERPRISE CO LTD',NULL,'PP01130',NULL,NULL,NULL,NULL,NULL,NULL); 
INSERT INTO NEWTABLE VALUES ('PANASONIC','3004','Manufacturer','Approved','10th Fi.,National No. 6, Bldg.,1-1-30,Shibadaimon,Minato-ku,','Minato-ku',NULL,NULL,'105-8586','81-3-54728222','PANASONIC GOBEL ELECTRONIC COMPONENTS',NULL,'SS00360','Panasonic',NULL,NULL,NULL,NULL,NULL); 
INSERT INTO NEWTABLE VALUES ('PROSOFT SCITECHNOLOGY','3009','Manufacturer','Disqualified','# 8,Caitang Industry Park, Lvling Road, Huli District, 
Xiamen, Fujian 361009, China','XiaMen',NULL,NULL,'N/A','86-592-59057000-206','PROSOFT SCITECHNOLOGY (XIAMEN)CO.,LTD.','Anny Chen','PP16140',NULL,NULL,NULL,NULL,NULL,NULL); 

我正在使用 dbeaver 进行我的 sql 操作。数据库是Oracle

Answer 1

有同样的问题，如果您没有看到评论，您必须从菜单或使用 alt+x 而不仅仅是查询来“执行脚本”。