Hi,
This is my table:
create table testbis (id NUMBER , action char(2),status char(2),nra int NULL,list_se varchar2(50)NULL);
insert into testbis (id,action,status) values (0,'t0','p');
insert into testbis (id,action,status) values (1,'SE','VS');
insert into testbis (id,action,status) values (2,'RA','p');
insert into testbis (id,action,status) values (3,'SE','VS');
insert into testbis (id,action,status) values (4,'SE','VS');
insert into testbis (id,action,status) values (5,'RA','P');
insert into testbis (id,action,status) values (6,'RA','P')
How can I have (calculate) the count of rows with action=RA and ID > than last previous SE in NRA column and concatanation of IDs of all previous SE rows in LIST_SE column of each RA row?
Hope be clear enough.
For example:
Thanks.