Spool file name date auto generated in oracle

SET MARKUP HTML ON

column dcol new_value mydate noprint

select to_char(sysdate,'DDMMYYYY') dcol from dual;

spool abc_&mydate..html

SELECT * FROM EMP ;

spool off

set markup html off

 

 

This generates a file called  “abc_<date>.html”