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

spool SYS_RUNTIME_REQUEST_STAT_DAY.log

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

create table SYS_RUNTIME_REQUEST_STAT_DAY
(
  STAT_DATE   DATE not null,
  URL         VARCHAR2(300) not null,
  ACTION_NAME VARCHAR2(200) not null,
  TOTAL_COUNT NUMBER,
  AVG_TIME    NUMBER,
  MAX_TIME    NUMBER,
  MIN_TIME    NUMBER,
  MEDIAN_TIME NUMBER
);

spool off

exit