Have Unpivot Automatically Grab Column List (oracle 11g)

This is a follow up question to Transpose one row into many rows Oracle I want to be able to unpivot an arbitrary query result. To unpivot a table manually, I would do: select va

Solution 1:

You could create a stored procedure to do this in PL/SQL by dynamically creating your SQL statement as a string an then using execute immediate to execute it and return a cursor.