text: SET ECHO      OFF;
  SET TIMING    OFF;
  SET HEADING   OFF;
  SET VERIFY    OFF;
  SET TERMOUT   OFF;
  
  SET LINESIEE	8000;
  SET PAGESIZE	0;
  SET FEEDBACK	ON;
  SET TRIMOUT 	ON;
  
  SET TRIMSPOOL ON;
  
  COLUMN DT NEW_VALUE SYSDATE NOPRINT;
  SET DEFINE ON;
  SELECT TO_CHAR(SYSDATE, 'YYYYMMDD') DT FROM DUAL;
  SPOOL log-&SYSDATE..log
  
  /*---- commons sql commands ------------*/
  WHENEVER OSERROR EXIT 1;
  WHENEVER SQLERROR EXIT 2;
  
  /*---- executable sql query/queries ----*/
  SELECT * FROM DUAL
  ;
  
  SPOOL OFF;
  
  EXIT 0;
  