Set echo on/off,set term on/off,set feedback off,set heading off command (RPM)

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)