Run dynamic SQL in SQL. This package allows queries with an unknown number of select-list items and can solve challenging problems like dynamic pivoting.

The "in tab" procedure displays what's in a table, using DBMS_SQL and method 4 dynamic SQL. That is, I do not know at the time I compile my code how many columns I will displaying. Most dynamic SQL ...