Re: Find all tables with a particular field

From: Fred Wilson <faNOWilsonSPAM_at_comcast.net>
Date: Wed, 20 Sep 2006 19:08:27 -0400
Message-ID: <xZmdnXUGG6dUVIzYnZ2dnUVZ_r2dnZ2d@comcast.com>

Not to sound too stupid, but do I type the select statement directly in SQLPlus?

I can hold my own in Access but this Oracle is a whole new world for me.

Thanks,

Fred

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.
Received on Wed Sep 20 2006 - 18:08:27 CDT