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

spool EXP_EMPLOYEES_S.log

prompt
prompt Creating sequence EXP_EMPLOYEES_S
prompt ============================
prompt

---create exp sequence 
whenever sqlerror continue
drop sequence EXP_EMPLOYEES_S ;
whenever sqlerror exit failure rollback
create sequence EXP_EMPLOYEES_S 
minvalue 100000
maxvalue 999999999999999999999999999
start with 100000
increment by 1
cache 20;



                                   
spool off

exit
