Dears ,
I have an old table where to code grouped by text as shown below
| SERIAL | COMPANATION | DESCRIPTION |
| 1 | | SHOP1 |
| 2 | | SHOP2 |
| 3 | | SHOP3 |
| 4 | 3,2 | SHOP4 |
| 5 | | SHOP5 |
| 6 | 5,1 | SHOP6 |
| 7 | | SHOP7 |
means serial 4 is a group of serial 2 and 3 and serial 6 group of 1 and 5
i would like to get the bleow output, which create extra column in select statement to show me the serial is belong to which group
| SERIAL | COMPANATION | DESCRIPTION | LINK |
| 1 | | SHOP1 | SHOP6 |
| 2 | | SHOP2 | SHOP4 |
| 3 | | SHOP3 | SHOP4 |
| 4 | 3,2 | SHOP4 | |
| 5 | | SHOP5 | SHOP6 |
| 6 | 5,1 | SHOP6 | |
| 7 | | SHOP7 | |
CREATE TABLE SPLIT_COMMA (SERIAL NUMBER,COMPANATION VARCHAR2(20),DESCRIPTION VARCHAR2(50));
INSERT INTO SPLIT_COMMA VALUES (1,'','SHOP1');
INSERT INTO SPLIT_COMMA VALUES (2,'','SHOP2');
INSERT INTO SPLIT_COMMA VALUES (3,'','SHOP3');
INSERT INTO SPLIT_COMMA VALUES (4,'3,2','SHOP4');
INSERT INTO SPLIT_COMMA VALUES (5,'','SHOP5');
INSERT INTO SPLIT_COMMA VALUES (6,'5,1','SHOP6');
INSERT INTO SPLIT_COMMA VALUES (7,'','SHOP7');
help please.