全部博文(45)
分类: Oracle
2011-04-12 16:28:43
> spool d:output.txt;
> spool off;
SQL>set colsep' '; //-域输出分隔符
SQL>set echo off; //显示start启动的脚本中的每个sql命令,缺省为on
SQL>set echo on
SQL>set feedback off;
SQL>set heading off;
SQL>set pagesize 0;
SQL>set linesize 80;
SQL>set numwidth 12;
SQL>set termout off;
SQL>set trimout on; //去除标准输出每行的拖尾空格,缺省为off
SQL>set trimspool on; //去除重定向(spool)输出每行的拖尾空格,缺省为off
SQL>set serveroutput on;
SQL>set timing on;
SQL>set autotrace on;
SQL>set verify off
set wrap on/off
set linesize