Re: SQL problem

From: Tommi Kilpua <tommi.kilpua_at_samstock.com>
Date: Wed, 12 Dec 2001 13:49:13 GMT
Message-ID: <tfJR7.5972$zZ5.120311@news.kpnqwest.fi>

Thanks Niall, problem solved with these views

Regs,

-Tommi-

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3c175f6c$0$230$ed9e5944_at_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_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 Wed Dec 12 2001 - 07:49:13 CST