some sql scripting hints

generate dynamic filenames

to generate dynamic spool filenames use (name will be set at the select):

col spoolfile new_val spoolfile
select 'log_' ||to_char(sysdate, 'yymmdd_hh24miss' ) spoolfile from dual;

spool &spoolfile

to be continued 😉