spool命令
来源:百度文库 编辑:神马文学网 时间:2024/07/01 13:55:29
set wrap off
set linesize 120 or col table_name for a12 ,col bytes for 999,999,999 and so on
set head off
set feedback off
set termout off
spool c:/test.txt
DML OR DDL
spool off----------------------------------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
set linesize 120 or col table_name for a12 ,col bytes for 999,999,999 and so on
set head off
set feedback off
set termout off
spool c:/test.txt
DML OR DDL
spool off----------------------------------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