title: Oracle SQL dynamically select a column
body: <p>I have multiple tables which all have the same structure --except a couple of them have one column misnamed.  I would like a sql statement that would allow the user to select that misnamed column using the correct name (there are only 2 possible names for the column-the correct one and the wrong one).  I was thinking I could have the query first look at the all_tab_columns view to look up the table and decide which spelling of that column the table has to retrieve the data...</p>