1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
create table T1 (ID integer, code varchar2(10), valeur varchar2(10));
insert into T1 values (1,'A', 'a1');
insert into T1 values (2,'B', 'b2');
insert into T1 values (3,'A', 'a3');
insert into T1 values (4,'C', 'c4');
insert into T1 values (1,'B', 'b1');
insert into T1 values (6,'D', 'd6');
insert into T1 values (1,'C', 'c1');
insert into T1 values (2,'C', 'c2');
commit;
SELECT SYS_CONNECT_BY_PATH(valeur, ';')
FROM ( SELECT id, code, valeur, ROW_NUMBER() OVER (PARTITION BY id ORDER BY code) FROM t1 a ) rk
CONNECT BY prior rk = rk -1
AND prior id = id; |
Partager