且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL * Plus脚本执行两次

更新时间:2023-02-05 19:44:00

使您的脚本也可以执行;

Make your script do either;

DELETE FROM f2020.SOCIETES
/

DELETE FROM f2020.SOCIETES;

不带斜杠.

从文档中:

/(斜杠)

/(slash)

执行存储在SQL缓冲区中的最近执行的SQL命令或PL/SQL块.

Executes the most recently executed SQL command or PL/SQL block which is stored in the SQL buffer.

,在示例中更进一步:

输入斜杠(/)以重新执行缓冲区中的命令

Enter a slash (/) to re-execute the command in the buffer

...这正是您所看到的.

... which is exactly what you are seeing.