Hi,
What I am trying is to, redo the sequence numbers of my data to remove gaps.

create sequence rtseq increment by 1;

create or replace view ldr1view as select name, seq from lrs_test order by name, seq;

drop table lrs8;

create table lrs8 as select ldr1view.*, rtseq.nextval sequence from ldr1view;

update lrs_test u set seq =
(select (a.sequence - minseq.minval) +1
from lrs8 a, (select name, min(sequence) minval from lrs8 group by name) minseq where u.name = a.name and u.seq = a.seq and a.name = minseq.name);
This seems to be working, but is there a better way to do this?

Please let me know.

badrinath