I am using PL SQL with an Oracle Database. I have several hundred tables. Trying to find a needle in a haystack.
Also If you know of any Open Source or free tools if you know of that might work better I am listening.
I am wondering if it is possible to QUICKLY....without having to MANUALLY type the names of every single field in a Table with hundreds of fields in each table.
I am hoping I can somehow start with this:
select * from OracleDB.Table1 WHERE Field1 = 1234
Is there a command or way to add all fields in from a given table and check for a specific record in all of them..?
And if per se it is a number field or string field a way to select all string or number fields exclusively and have it look for a record
Like EIther Field1 = 1234 or field1 = "1234"
May be wishful thinking. I have to find where a specific set of records are stored in an Oracle DB that no one even me is familiar with.
Doing the best I can just looking for a way to shorten this before my EYE's pop out of my head....!!!!