Oracle script runtime template

set serveroutput on;
alter session enable parallel dml; –NB: not possible within partition or on non-partitioned table for delete/update/merge operations
alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’;
select sysdate as script_start from dual;

<STUFF>

select to_char(sysdate, ‘YYYY/MM/DD HH:mi:ss’) as script_end from dual;