Re: Find all tables with a particular field

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 20 Sep 2006 11:05:29 -0700
Message-ID: <1158775527.224252@bubbleator.drizzle.com>

Jaap W. van Dijk wrote:
> On Mon, 18 Sep 2006 17:01:47 -0700, DA Morgan <damorgan_at_psoug.org>
> wrote:
>
>

>> The one you are looking for is: xxx_tab_columns.
>> -- 

>
> This view gives the columns of all tables * and views *. The OP only
> wanted columns of tables so he has to eliminate the views from this
> view.
>
> Jaap.

"so he has to eliminate the views from this view."

We are not communicating well. I thought the OP wanted to know which objects contained a specific column name such as:

SELECT table_name
FROM user_tab_columns
WHERE column_name = 'EMPID';

-- 
Daniel Morgan
Puget Sound Oracle Users Group

Received on Wed Sep 20 2006 - 13:05:29 CDT