PL/SQL Developer SQL Window中不能插入多條資料

來源:互聯網
上載者:User

需要執行的SQL如下:

insert into user(username) value('a');

insert into user(username) value('b');
insert into user(username) value('c');
insert into user(username) value('d');

在SQL Window中執行時報錯:ORA-00911 invalid character無效字元),因為句末的“;

點擊“new”按鈕,選擇“command window”,將需要執行的SQL複製後粘貼即可。

數量較大時建議儲存為sql檔案,用“@”命令執行)

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.