-
how to remove prompt out put
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
-
-
Thank you very much.
xyz2000
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|