From: "Tommi Kilpua" <tommi.kilpua@samstock.com>
Newsgroups: comp.databases.oracle.server
References: <e_IR7.5971$zZ5.120414@news.kpnqwest.fi> <3c175f6c$0$230$ed9e5944@reading.news.pipex.net>
Subject: Re: SQL problem
Lines: 46
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
Message-ID: <tfJR7.5972$zZ5.120311@news.kpnqwest.fi>
Date: Wed, 12 Dec 2001 13:49:13 GMT
NNTP-Posting-Host: 194.142.156.140
X-Complaints-To: helpdesk@kpnqwest.fi
X-Trace: news.kpnqwest.fi 1008164953 194.142.156.140 (Wed, 12 Dec 2001 15:49:13 EET)
NNTP-Posting-Date: Wed, 12 Dec 2001 15:49:13 EET
Organization: KPNQwest Finland customer news service
Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!newsfeeds.belnet.be!news.belnet.be!news.tele.dk!small.news.tele.dk!213.131.157.171!newsfeed1.wineasy.se!newsfeed.song.fi!news.cs.hut.fi!newsfeed2.funet.fi!newsfeed3.funet.fi!newsfeeds.funet.fi!newsfeed.kpnqwest.fi!news.kpnqwest.fi!not-for-mail
Xref: easynews comp.databases.oracle.server:127948
X-Received-Date: Wed, 12 Dec 2001 06:49:57 MST (news.easynews.com)

Thanks Niall, problem solved with these views

Regs,

-Tommi-

"Niall Litchfield" <n-litchfield@audit-commission.gov.uk> wrote in message
news:3c175f6c$0$230$ed9e5944@reading.news.pipex.net...
> 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-
> >
> >
>
>