Re: Spooling to a dynamic file name with SQL*Plus
From: kedar_s_s <member_at_dbforums.com>
Date: 3 Aug 2001 05:02:20 -0500
Message-ID: <3b6a689c$1_at_usenetgateway.com>
Date: 3 Aug 2001 05:02:20 -0500
Message-ID: <3b6a689c$1_at_usenetgateway.com>
spool e:\sql_scripts\temp.sql SELECT 'spool '||name ||'_FS_'||TO_CHAR(sysdate,'MM-D-YYYY') || '.txt;' dynfil FROM dual,temp_table; spool off; _at_temp.sql; rem you can write ur query here..this query will be stored in the rem dynamic file.. spool off;
-- Attitude is Everything Posted via dBforums, http://dbforums.comReceived on Fri Aug 03 2001 - 12:02:20 CEST