On Dec 19, 1:45 pm, Homer <HomerS..._at_gmail.com> wrote:
> Hi,
>
> I need a way to find all the tables whose field contains a certain
> value. The problem I'm encountering is the vendor software uses
> oracle database and it has countless number of tables (around 1,000).
> To top it off, the table name does not match the front-end. I'm
> trying to find all the tables that has 'Finance' as a department
> field. Can this be done?
>
> Thank you,
> Jon
Let's see if I understand this correctly. You want to identify any
table that might have a particular value ('Finance') occurring in any
column of any row. Is that correct?
Received on Wed Dec 19 2007 - 14:16:42 CST
