set termout off COLUMN X NEW_VALUE Y SELECT LOWER('used_option_details.' || SYS_CONTEXT('userenv', 'server_host') || '.' || SYS_CONTEXT('userenv', 'instance_name') || '.' || to_char(sysdate, 'yyyymmdd') || '.log') X FROM dual; ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'; ALTER SESSION SET NLS_TIMESTAMP_FORMAT='DD-MON-YYYY HH24:MI:SS.FF'; set lines 200 pages 9999 set echo off feedback off trims on space 0 head on set define off set define & spool '&Y' @lcs_used_options_details spool off set termout on