Column name from value

[shers]

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

[VictorN]

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.

[crowdfinch]

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