Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to find all tables using a field value

How to find all tables using a field value

From: Homer <HomerS007_at_gmail.com>
Date: Wed, 19 Dec 2007 11:45:02 -0800 (PST)
Message-ID: <f600c542-460e-496a-9472-575100b78732@b1g2000pra.googlegroups.com> 





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
Received on Wed Dec 19 2007 - 13:45:02 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US