Re: How to find all tables using a field value

On Dec 19, 2:51 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Dec 19, 1:41 pm, Homer <HomerS..._at_gmail.com> wrote:

> The other alternative, if the column name is stable like "DEPARTMENT",
> is to simply write sql to generate a sql select, for each table in
> dba_tabl_cols that has the column. Find all the tables with the
> column, then look at all those tables for the value.

err, dba_tab_columns

jg

--
@home.com is bogus.
Snoopy, the mad punter.