-----a.sql------
set head off;
set show off;
set trims on;
set feed off;
set term off;spool aa.log ;
@test.sql 21212;
spool off;
exit;------test.sql------
select &1 from dual ;
select current_date from dual;
select &1 from dual ;执行:sqlplus ???/???@??? @a.sqlmore aa.log
old 1: select &1 from dual
new 1: select 21212 from dual 2121201-NOV-06
old 1: select &1 from dual
new 1: select 21212 from dual 21212
怎么样让这样的行不显示?(我只是想输出数据和标题)
old 1: select &1 from dual
new 1: select 21212 from dual
set head off;
set show off;
set trims on;
set feed off;
set term off;spool aa.log ;
@test.sql 21212;
spool off;
exit;------test.sql------
select &1 from dual ;
select current_date from dual;
select &1 from dual ;执行:sqlplus ???/???@??? @a.sqlmore aa.log
old 1: select &1 from dual
new 1: select 21212 from dual 2121201-NOV-06
old 1: select &1 from dual
new 1: select 21212 from dual 21212
怎么样让这样的行不显示?(我只是想输出数据和标题)
old 1: select &1 from dual
new 1: select 21212 from dual
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货