SQL & PL/SQL

Hello All,

I am trying to spool my filename with sysdate in a specific format but when I run the commands below, my file name is f.csv . And when I run spool c:\&f.csv with &, i get prompted. I do not want to get prompted. I want my filename to be YYYY_MMDDYYYY_HO15SL.csv. Any ideas?

SET SERVEROUTPUT ON size unlimited;

COLUMN f new_value f;

SELECT TO_CHAR(SYSDATE,'YYYY')||'_'||TO_CHAR(SYSDATE,'MMDDYYYY')||'_'||'HO15SL FROM dual;

spool c:\f.csv;

select ;

spool off;

Thanks,

KJ