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

Source: Internet
Author: User
Tags sqlplus

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.