i created a sequence and take the nextval from it but i want to rollback this operation to return to previous next value ? is there any way to achieve this, if so please guide me.
Question
Oraask Latest Questions
Question
How to use automatic nextval from sequense in OAF ?
Question
Hi, Oracle : 9.2.0.8.0 We have sequence as below: [code] CREATE SEQUENCE TEST_SEQ START WITH 41554558016 INCREMENT BY 2 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 40 NOORDER; [/code] We have written a procedure to increment the sequence value based on another sequence value by comparing the two values. But when I execute the procedure ...
Question
I want to create new column say (ID) with auto generated sequence number with auto increment by 10.how can I achieve this in oracle database 11g ?