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 Group
Received on Wed Sep 20 2006 - 22:56:32 CDT
