Hello Oracle Community,
I want to create an new query, where I have to bring the records to the projection, each value as a new column. Problem with Pivot is, I cannot use a dynamic IN list with a subquery. Problem of using PIVOT XML is, I get only one column in return. So is there any trick I can solve my problem without using PL/SQL, Dynamic SQL or creating types and functions ?
DataVader