I try to change the value of LAST_NUMBER in a sequence in sql developer v4 using the graphical interface only. When I click the edit icon next to the value I am unable to change the field. What I see is following:
My question is: is there a way to edit the value inline using only the graphical interface?
You can't change LAST_NUMBER, it's the database's internal record of the highest value reserved in the cache and written to disk for crash recovery. You generally can't (and shouldn't) change anything in the data dictionary.
If you want to reset the sequence to 1 then you can change the increment to a negative value (equal to the current value) and call nextval, then change the increment back to 1; or drop and recreate the sequence; or from 12c you can explicitly restart it. Since you're on 11g see How do I reset a sequence in Oracle?.
You could do some of that from the SQL Developer object viewer, but not in one step. You can change the increment by clicking on the edit button right under the 'details' tab, but would then have to call nextval somewhere else before changing back. And you could drop the sequence from the 'actions' drop-down, but then you'd need to recreate it as a separate action.
you can get sql from 3rd tab of added in current snap given and change initial value from it and create sequence again with same name to reset it from 1.
click on marked edit button and enter value to start with in "Start with" textbox.
