Hi,
I have a table called SetupTable, which contains 35 attributes. all the attributes a re of type Char(1), ususally contain either 'y' or 'n' .

So, i need a query to display the column name and the value , whose value is 'y' per each row.

is it posible in Oracle 11g ??


Appriciate the quick response.