Need data in a specific manner

Asked May 08 '18 at 13:42

Active May 08 '18 at 13:43

Viewed 48 times

I have data in table :

A    B    c
1    2    3,4,5
11   12   13,14

I want data to be converted like:

A   B     C
1   2     3
1   2     4
1   2     5
11  12    13
11  12    14

edited May 08 '18 at 13:43

Ivar

asked May 08 '18 at 13:42

Kuldeep Gurav

Great! Those comma separated items are a mess. – jarlh May 08 '18 at 13:43
I want a question to be like that https://stackoverflow.com/help/mcve )) – oreh May 08 '18 at 13:46
Look at the LISTAGG(). – Art May 08 '18 at 13:50
@TimBiegeleisen, you have an Oracle silver badge, while I only have a bronze one. – jarlh May 08 '18 at 13:51
While there are (ugly) ways of doing this within Oracle, it might even be easier to handle outside the database. Maybe you can find a way to reimport your data in a normalized format. – Tim Biegeleisen May 08 '18 at 13:52
1

I also think it's a dupe. I have an SQL gold badge but little to no experience with Oracle so don't look at me, I'm not going to close this one :-) – Zohar Peled May 08 '18 at 13:52
If it were tagged Oracle 12c, I would not have closed it, because there are other solutions possible in that version. – Gordon Linoff May 08 '18 at 13:57

0 Answers0