Skip to Main Content

split comma to use it in condition

prooraDec 6 2016 — edited Dec 14 2016

Dears ,

I have an old table where to code grouped by text as shown below

   

SERIALCOMPANATIONDESCRIPTION
1 SHOP1
2 SHOP2
3 SHOP3
43,2SHOP4
5 SHOP5
65,1SHOP6
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

    

SERIALCOMPANATIONDESCRIPTIONLINK
1 SHOP1SHOP6
2 SHOP2SHOP4
3 SHOP3SHOP4
43,2SHOP4
5 SHOP5SHOP6
65,1SHOP6
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.

This post has been answered by RogerT on Dec 6 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jan 3 2017
Added on Dec 6 2016
5 comments
324 views