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

spool sys_runtime_req_top_use.log



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

create table sys_runtime_req_top_use
(
       id     number,
       day    date           not null,
       url    varchar2(200)  not null,
       visits number         not null
);
create index req_top_use_idx1 on sys_runtime_req_top_use(day);
alter table sys_runtime_req_top_use add primary key (id);

spool off
exit