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


spool GLD_SET_OF_BOOKS_S.log
prompt
prompt Creating sequence GLD_SET_OF_BOOKS_S
prompt ====================================
prompt
whenever sqlerror continue
drop sequence GLD_SET_OF_BOOKS_S;
whenever sqlerror exit failure rollback

create sequence GLD_SET_OF_BOOKS_S
minvalue 100000
maxvalue 999999999999999999999999999
start with 100000
increment by 1
cache 20;


spool off

exit