and also, it is required to stop the spool because the spool terminates the output of the file off command. Once the configuration is done and the spool is executed, then it should get inserted in the query. As an example, if we are printing the available courses from the...
ORACLE语句将SCOTT用户下的EMP表并进行到处文本文件:使用SQLPlus的spool命令 操作步骤 1.新建一个脚本文件,存放起来,如D:\spool.sql,具体代码如下 :set echo off --在用start命令执行一个sql脚本时,是否显示脚本中正在 sqlplus登陆Oracle。set eacho onset head onset feedback onset autotrace traceonlyspool D:/e...