Oracle - How create a sequence
Use
drop sequence <sequence_name>; create sequence <sequence_name> start with <integer> increment by <integer>;
Example
drop sequence SEQ_EXAMPLE; create sequence SEQ_EXAMPLE start with 1 increment by 1;
select * from ALL_SEQUENCES;