Hi,
The problem am facing is according to the below example

column col1 new_value myfile noprint
select to_char(sysdate,'YYYYMMDD') col1 from dual;
---------------------------
(If I use single &, then I get on my c:\ file name as &myfile.txt)
spool c:\&myfile.txt
.
.
spool off
---------------------------

---------------------------
(If I use double &&, then I get on my c:\ file name as &20031230.txt)
spool c:\&&myfile.txt
.
.
spool off
---------------------------
I don't know what part I am missing, what I should perform in order to get the the proper file name like 20031230.txt


Thanks.