-
I am trying to create a script by spooling my output from SQLPlus to a file. I use set echo off, set verify off, set feedback off and I am still getting my select statement end the spool off on the spool file. Does anyone know what else I have to turn off to just get my output into the spool file?
SQL>select '@c:\temp\retention\process_table.sql '||owner||' '||table_name||' '||
2 retention_column||' '||days
3 from retention
4 where last_update + days <= sysdate;
@c:\temp\retention\process_table.sql OWNERR TABLE_NAME activity_date 90
@c:\temp\retention\process_table.sql OWNER TABLE_NAME activity_date 90
EVEDEV.US.HSBC>spool off;
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
|