sql 代码
- set pagesize 0 //去掉头顶的空行
- set linesize 250 //设置行字符数
- set trims on //去掉空字符
- set echo off //关掉回显
- set heading off //关掉标题行
- set termout off //关掉终端显示
- set feedback off//关掉行数显示
- spool spooltxt.txt
- select command ...
- spool off
- ------------------------------------
- 去掉头行SQL>select command和尾行SQL>spooloff的方法
- 先在os下写个sql文件,如:gen.sql
- 内容如下
- ------------------------------------
- set pagesize 0 lin 250 echo off heading off termout off feedbackoff trims on
- spool sp.sql
- select decode(line,1,'CREATE OR REPLACE '||text,text) fromuser_source where name='SP_EMS_RBD';
- spool off
- exit
- -----------------------------------
- 然后在os下输入sqlplus ems/ems @gen.sql