1.termorder:
When used in conjunction with the spool command, the Sqlplus output can be canceled, and the query results exist only in the spool file
Set term on: The query results are displayed both in the spool file and in the Sqlplus;
Set term off: The query results are displayed only in the spool file.
2. Other commands:
Sql>set colsep ' | '; -Field Output delimiter
Sql>set echo off; Displays each SQL command in the script started by the start, which defaults to on
Sql> set echo on//Set Run command is whether to display statements
Sql> set feedback on; Set display "XX row selected"
Sql>set feedback off; echo the number of record bars processed by this SQL command, default to ON
Sql>set heading off; Output field header, default to On
Sql>set pagesize 0; Output number of rows per page, default is 24, in order to avoid paging, can be set to 0.
Sql>set Linesize 80; Output one line of characters, default is 80
Sql>set Numwidth 12; Output Number Type field length, default is 10
Sql>set termout off; Displays the execution result of the command in the script, which is on by default
Sql>set trimout on; Remove trailing spaces per line of standard output, default to Off
Sql>set Trimspool on; Remove redirect (spool) output trailing spaces per line, default to OFF
Sql>set serveroutput on; Set allow display output similar to Dbms_output
Sql> set timing on; Set display "Time used: XXXX"
Sql> set autotrace on; Settings allow parsing of executed SQL
Set verify off//can turn off and turn on the display of the prompt confirmation information old 1 and new 1.
http://blog.csdn.net/ziyifengfei/article/details/9964161
This is some of the settings when you run the query with Sqlplus.
Set echo off; #控制start命令不列出命令文件中的每一命令
Set feedback off; #显示由查询返回的记录数 off is equivalent to 0
Set heading off; #报表中列标题不打印
Set pagesize off; #置 the number of rows from the top header to the end of the page
Set Linesize off; #置一行中显示的字符总数
Set Termout off; #由文件执行命令时不显示输出
Set trimout on; #每一显示行的末端去掉空格
Set Trimspool on; #去掉spool输出时每行末端空格
Col eventtypeid format A10; #字段eventtypeid output is formatted as a text type and is 10 characters wide, similar to the following
Col eventtime format A10;
Col srcip format A16;
Col dstip format A16;
Col srcport format A10;
Col dstport format A16;
Spool D:/home/oracle/http.txt; #将下面开始的输出记录到这个文件
Select Eventtypeid, Eventtime,srcip, Srcport, Dstip, Dstport, param from Netids_eventlog t; #查询语句
Spool off; #输出记录结束
http://zhidao.baidu.com/link?url=oPSpftBT_LAQnwDYSM7NgGRuli89oLWnPi6Yo9XtHidode00fEjpJWTST9qtS8ZFwlyuiBmRZBTZ9397KffMaq#
Set echo on/off,set term on/off,set feedback off,set heading off command (RPM)