Column name from value

Hi,

I have a datarow retrieved from a datatable. I have a value that exists in some column in the datarow. I want to find which column this value is in. How can I achieve this please?

Thanks

Loop through the fields of the "datarow" to find the value that equals your "value".
Note that there may be many fields with the same value.

SELECT * from dba_objects
WHERE object_name like '%DTN%'