Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Find all tables with a particular field
Fred Wilson wrote:
> 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.
Yes. But not the one above as it is intended as a model. 'xxx' is intended to stand for dba as in dba_tab_columns, all as in all_tab_columns, or user, as in user_tab_columns.
-- Puget Sound Oracle Users GroupReceived on Wed Sep 20 2006 - 22:56:32 CDT
![]() |
![]() |