问题描述
我有一个关于假脱机程序结果的问题.我的示例 sql 脚本如下所示.
I have a question about spooling the the results of my program. My sample sql script looks like this.
上面的脚本不起作用,但我想做这样的事情,在开始结束块中我们计算一些值,我想假脱机这些结果.
The above script does not work, but I want to do something like this where in the begin end block we compute some values and i want to spool those results.
谢谢.
推荐答案
这会将匿名块的输出假脱机到名为 output_<YYYYMMDD>.txt
的文件中,该文件位于本地的根目录中PC C:驱动器,其中
是当前日期:
This will spool the output from the anonymous block into a file called output_<YYYYMMDD>.txt
located in the root of the local PC C: drive where <YYYYMMDD>
is the current date:
希望能帮到你...
在您评论后为游标的每次迭代输出一个值(我意识到在这个例子中每个值都相同,但您应该了解我正在做的事情的要点):
After your comment to output a value for every iteration of a cursor (I realise each value will be the same in this example but you should get the gist of what i'm doing):
这篇关于如何创建一个 oracle sql 脚本假脱机文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!