Home
> Uncategorized > some sql scripting hints
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 😉
Categories: Uncategorized
Comments (0)
Trackbacks (0)
Leave a comment
Trackback