I’ve tried using this statement below to find an appropriate column based on what I think it should be named but it returned no results :
SELECT * from dba_objects WHERE
object_name like '%DTN%'
A column isn't an object. If you mean that you expect the column name to be like '%DTN%', the query you want is:
SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%DTN%';
Comments
Tags: database, Find A String In Database, Oracle, Oracle data files, Oracle DBA