OraFAQ Forum: SQL & PL/SQL » how to create dynamic spool

Home » SQL & PL/SQL » SQL & PL/SQL » how to create dynamic spool (oracle 8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to create dynamic spool [message #311864]

Mon, 07 April 2008 03:11

melvinRav
Messages: 43
Registered: April 2008
Location: India

Member

I have the following script

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 180
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
spool c:\test.txt
select * from emp ;
spool off
I want to create a dynamic spool name of the format allemp_dd_mm_yy.csv
wher the date is dependent on the sysdate

is there a way to create such a spool name of such a type

Report message to a moderator