Transpose ROW to COLUMN
HI, I have a big problem.
I need to transpose the table rows into columns.
The number of lines changes.
What is a dynamic query or procedure to do this?
The number of the result columns changes.
DAY user app num_events duration volume
2015-10-01 00 pippo facebook 1 44 2037
2015-10-01 00 pippo youtube 9 984 48256
2015-10-01 00 pippo whatsapp 1 28 3
2015-10-01 01 pippo youtube 1 531 24306
2015-10-01 12 pippo facebook 1 925 41762
TNKS
ILIO
Subject
Written By
Posted
February 22, 2016 09:08AM
Transpose ROW to COLUMN
February 22, 2016 09:16AM
February 22, 2016 11:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.