looking for some solutions? You are welcome.

SOLVED: How to perform opposite of LISTAGG in Oracle

Rahul Goyal:

I have a table named "Table1".

Given Table

Now, how to write a query so that all comma separated values are represented separately in new row

The output would look something like below table

Resultant Table

I know about listagg but i don't have any idea about how to do the opposite of what I mentioned above.



Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots
Share:

No comments:

Recent