Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!newsfeed.esat.net!tank.news.pipex.net!pipex!lnewspeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Newsgroups: comp.databases.oracle.server
References: <e_IR7.5971$zZ5.120414@news.kpnqwest.fi>
Subject: Re: SQL problem
Date: Wed, 12 Dec 2001 13:44:00 -0000
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Lines: 36
Message-ID: <3c175f6c$0$230$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: host9.audit-commission.gov.uk
X-Trace: 1008164716 reading.news.pipex.net 230 193.128.236.219
X-Complaints-To: abuse@uk.uu.net
Xref: easynews comp.databases.oracle.server:127945
X-Received-Date: Wed, 12 Dec 2001 06:45:38 MST (news.easynews.com)

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@samstock.com> wrote in message
news:e_IR7.5971$zZ5.120414@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-
>
>