[转载]10g中SPOOL内容追加至文件
<p>信息来源: ccidnet</p><p>以前在SQLPLUS中运行脚本时用SPOOL保存运行结果, 可是SPOOL每次都将原来的文件覆盖了, 现在有了10g就没这个问题了<font size="2">：</font> </p><p /><div style="SCROLLBAR-HIGHLIGHT-COLOR: buttonhighlight; OVERFLOW: auto; WIDTH: 500px"><pre style="BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: black 1px solid; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: black 1px solid; PADDING-TOP: 4px; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #ededed"><div id="3"><div><span style="COLOR: #000000">e:</span><span style="COLOR: #808080">></span><span style="COLOR: #000000">sqlplus xsb</span><span style="COLOR: #008000">@tns1</span><span style="COLOR: #000000">SQL</span><span style="COLOR: #808080">*</span><span style="COLOR: #000000">Plus: Release </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> Production </span><span style="COLOR: #0000ff">on</span><span style="COLOR: #000000"> 星期四 4月 </span><span style="FONT-WEIGHT: bold; COLOR: #800000">13</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">15</span><span style="COLOR: #000000">:</span><span style="FONT-WEIGHT: bold; COLOR: #800000">24</span><span style="COLOR: #000000">:</span><span style="FONT-WEIGHT: bold; COLOR: #800000">36</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2006</span><span style="COLOR: #000000">Copyright (c) </span><span style="FONT-WEIGHT: bold; COLOR: #800000">1982</span><span style="COLOR: #000000">, </span><span style="FONT-WEIGHT: bold; COLOR: #800000">2004</span><span style="COLOR: #000000">, Oracle. </span><span style="COLOR: #808080">All</span><span style="COLOR: #000000"> rights reserved.Connected </span><span style="COLOR: #0000ff">to</span><span style="COLOR: #000000">:Oracle </span><span style="COLOR: #0000ff">Database</span><span style="COLOR: #000000"> 10g Enterprise Edition Release </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> Production</span><span style="COLOR: #0000ff">With</span><span style="COLOR: #000000"> the Partitioning, OLAP </span><span style="COLOR: #808080">and</span><span style="COLOR: #000000"> Data Mining optionsSQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> spool </span><span style="FONT-WEIGHT: bold; COLOR: #800000">1</span><span style="COLOR: #000000">.txtSQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">*</span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> v$version;BANNER</span><span style="COLOR: #008080">--</span><span style="COLOR: #008080">--------------------------------------------------------------</span><span style="COLOR: #008080"></span><span style="COLOR: #000000">Oracle </span><span style="COLOR: #0000ff">Database</span><span style="COLOR: #000000"> 10g Enterprise Edition Release </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProdPL</span><span style="COLOR: #808080">/</span><span style="COLOR: #000000">SQL Release </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProductionCORE </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"> ProductionTNS </span><span style="COLOR: #0000ff">for</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">32</span><span style="COLOR: #808080">-</span><span style="FONT-WEIGHT: bold; COLOR: #000000">bit</span><span style="COLOR: #000000"> Windows: Version </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProductionNLSRTL Version </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProductionSQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> spool </span><span style="COLOR: #0000ff">off</span><span style="COLOR: #000000">SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> spool append </span><span style="FONT-WEIGHT: bold; COLOR: #800000">1</span><span style="COLOR: #000000">.txtSP2</span><span style="COLOR: #808080">-</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0108</span><span style="COLOR: #000000">: The filenames </span><span style="COLOR: #0000ff">CREATE</span><span style="COLOR: #000000">, </span><span style="COLOR: #ff00ff">REPLACE</span><span style="COLOR: #000000">, APPEND, </span><span style="COLOR: #0000ff">FILE</span><span style="COLOR: #000000">, </span><span style="COLOR: #808080">and</span><span style="COLOR: #000000"> abbreviations may </span><span style="COLOR: #808080">not</span><span style="COLOR: #000000"> be used.SP2</span><span style="COLOR: #808080">-</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0769</span><span style="COLOR: #000000">: Usage: SPOOL { </span><span style="COLOR: #808080"><</span><span style="COLOR: #0000ff">file</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"></span><span style="COLOR: #808080">|</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">OFF</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">|</span><span style="COLOR: #000000"> OUT }</span><span style="COLOR: #0000ff">where</span><span style="COLOR: #000000"></span><span style="COLOR: #808080"><</span><span style="COLOR: #0000ff">file</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">is</span><span style="COLOR: #000000"></span><span style="COLOR: #ff00ff">file_name</span><span style="COLOR: #ff0000">[</span><span style="COLOR: #ff0000">.ext</span><span style="COLOR: #ff0000">]</span><span style="COLOR: #000000"></span><span style="COLOR: #ff0000">[</span><span style="COLOR: #ff0000">CRE[ATE</span><span style="COLOR: #ff0000">]</span><span style="COLOR: #808080">|</span><span style="COLOR: #000000">REP</span><span style="COLOR: #ff0000">[</span><span style="COLOR: #ff0000">LACE</span><span style="COLOR: #ff0000">]</span><span style="COLOR: #808080">|</span><span style="COLOR: #000000">APP</span><span style="COLOR: #ff0000">[</span><span style="COLOR: #ff0000">END</span><span style="COLOR: #ff0000">]</span><span style="COLOR: #000000">]SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> spool </span><span style="FONT-WEIGHT: bold; COLOR: #800000">1</span><span style="COLOR: #000000">.txt appendSQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">*</span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> v$version;BANNER</span><span style="COLOR: #008080">--</span><span style="COLOR: #008080">--------------------------------------------------------------</span><span style="COLOR: #008080"></span><span style="COLOR: #000000">Oracle </span><span style="COLOR: #0000ff">Database</span><span style="COLOR: #000000"> 10g Enterprise Edition Release </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProdPL</span><span style="COLOR: #808080">/</span><span style="COLOR: #000000">SQL Release </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProductionCORE </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"> ProductionTNS </span><span style="COLOR: #0000ff">for</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">32</span><span style="COLOR: #808080">-</span><span style="FONT-WEIGHT: bold; COLOR: #000000">bit</span><span style="COLOR: #000000"> Windows: Version </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProductionNLSRTL Version </span><span style="FONT-WEIGHT: bold; COLOR: #800000">10.2</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0.1</span><span style="COLOR: #000000">.</span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">-</span><span style="COLOR: #000000"> ProductionSQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> spool </span><span style="COLOR: #0000ff">off</span></div></div></pre></div>页:
[1]