WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool SYS_RUNTIME_REQ_SUMMARY_HOUR_S.log

PROMPT
PROMPT CREATING SEQUENCE SYS_RUNTIME_REQ_SUMMARY_HOUR_S
PROMPT ============================
PROMPT
WHENEVER SQLERROR CONTINUE
DROP SEQUENCE SYS_RUNTIME_REQ_SUMMARY_HOUR_S;
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE SEQUENCE SYS_RUNTIME_REQ_SUMMARY_HOUR_S
minvalue 100000
maxvalue 999999999999999999999999999
start with 100000
increment by 1
cache 20;

spool off

exit
