Input:
https://dbfiddle.uk/cRwtWyjo
For each row, I want to select the column name that has the maximum value:
It's my understanding there isn't a succinct way to do that, such as a function that takes a list of column names and outputs the name of the column that has the maximum value, like this:
max_col(agr_forest_fish, mining_quarry, mfg, electric, water_sew)
As a novice, I'm wondering if Oracle could be enhanced by adding a function like that.