Re: SQL problem

Be aware that, although dba_tables, all_tables and user_tables only show tables, these views also show columns of views.

Jaap.

On Wed, 12 Dec 2001 13:44:00 -0000, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>you can query the views dba_tab_columns or user_tab_columns for this info.
>
>regards
>
>
>--
>Niall Litchfield
>Oracle DBA
>Audit Commission UK
>*****************************************
>Please include version and platform
>and SQL where applicable
>It makes life easier and increases the
>likelihood of a good answer
>
>******************************************
>"Tommi Kilpua" <tommi.kilpua_at_samstock.com> wrote in message
>news:e_IR7.5971$zZ5.120414_at_news.kpnqwest.fi...
>> Hi,
>>
>> As a beginner in SQL, I would appreciate help in this little problem: I
>need
>> to list all the tables in database which include columns COL, ID, CUS,
>CUS2
>>
>> like;
>> COL - table2, table5
>>
>> Is there any system-table where I could find this information? Thank you
>> very much in advance!
>>
>> -Tommi-
>>
>>
>
>
Received on Sun Dec 16 2001 - 05:16:22 CST