A reader, May 14, 2017 - 2:22 am UTC
How about - simply do
alter table t modify x generated as identity ( start with 1);
May 15, 2017 - 4:13 pm UTC
Yes indeed ! I didnt think that would be allowed, but it is.
Thanks for picking this up.
delete auto generate squence
A reader, December 05, 2018 - 1:23 pm UTC
as per above example, sequence name is like "ISEQ$$_70764" and i want to delete this sequence so how to possible?
when i use drop sequence ISEQ$$_70764 ; it's return an error.
December 12, 2018 - 3:31 am UTC