I'm looking to write an Oracle SQL query or procedure to bring back all table.columns in the schema where all rows for a given column are null. For example:
ID X Y Z
1 A E
2 B F
3 C G
The query should bring back:
as this is the only column where all rows are null.
Does anyone have an idea how to do this?
Thanks in advance.