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

spool SYS_RUNTIME_REQUEST_DETAIL.log

prompt
prompt Creating table SYS_RUNTIME_REQUEST_DETAIL
prompt ============================
prompt
whenever sqlerror continue
drop table SYS_RUNTIME_REQUEST_DETAIL;
whenever sqlerror exit failure rollback

create table SYS_RUNTIME_REQUEST_DETAIL
(
  REQUEST_ID   VARCHAR2(100) not null,
  SEQUENCE_NUM NUMBER not null,
  NAME         VARCHAR2(200),
  ENTER_TIME   DATE,
  EXIT_TIME    DATE,
  DURATION     NUMBER
)
;
alter table SYS_RUNTIME_REQUEST_DETAIL
  add primary key (REQUEST_ID, SEQUENCE_NUM);
  

spool off

exit