Searching all fields in an Oracle database.
Posted on 2015-02-01
I am working with a rather large Oracle database with thousands of tables. This is used for a Windows based application. Unfortunately the original developer is gone and my client ask for me to pull data out of the database.
As of now, I am trying to find the tables that contain specific pieces of data. I am attempting to do this based on values that I know exist in the database. I know these values are not generated by some type of formula or in a blob field. I am using
Oracle SQL Developer for this.
I have an extensive background in SQL, but not Oracle. Any suggestions regarding running a query to look for a column with one of the known values would be greatly appreciated.