I have 100+ columns. I need to retreive columns having a specific value [Say 'ABC'] in any of the rows.
You can write the filter condition using a dynamic SQL like this:
select trim(columnname)||'=''ABC'' or '
and tablename ='YourTable'
and columntype in('CF', 'CV')