SPOOL IN SQL PLUS

[JMac]

In the script I did ...


spool spoolfilename.sql

SELECT 'spool C:\Dest1\'||''File1_'||sysdate
FROM dual;
spool off

@spoolfilename

This spooled output to a File called, for example
File1_12-May-02
in my C:\Dest folder .