Hi,

I am using spool to dump a table.

Following is sql file.

set heading off
set feedback off
set termout off
spool &1
select * from &2..test;
spool off
exit

Following is the spool file

old 1: select * from &2..test
new 1: select * from xzhu.test

xyz2000

I want to remove following test:

old 1: select * from &2..test
new 1: select * from xzhu.test


Is there any way to do it?

Thanks.

xyz2000