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

No comments: