Hi All,
I need to generate a report which displays the columns which has data.
Here is my example,

So my sample table has num1 ... num3 and col1.. col3. And you can see there is completely no data for the columns Num2 and Col2 which I need to exclude while generating the report.
My final output should be like this
NOTE - The above case is just a sample, actual data and number of columns will vary.
What will be best way to achieve this.
I am using Oracle Database 12c (12.2.0.1.0 )
Thanks in advance,
Soofi