Adding Time of Execution to Spool File Name

Sometimes we need to create spool file and add time of execution to spool file name. This can be done as given below.

column filename noprint new_value filename SELECT 'table_listing_'||to_char(sysdate, 'mmddyy_hh24mi')||'.csv' filename FROM dual; -- -- Your Query -- SPOOL $HOME/&&filename SELECT table_name FROM dba_tables /