Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2. Suppose at this point we issue a rollback and again issue a nextval. What will the output be?
INCREMENT BY START WITH MAXVALUE | NOMAXVALUE MINVALUE | NOMINVALUE CYCLE | NOCYCLE CACHE | NOCACHE ORDER | NOORDER
Consider a sequence whose currval is 1 and gets incremented by 1. by using the nextval reference we get the next number 2. Suppose at this point we issue an rollback and again issue a nextval. What will the output be ?