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:44:00 CST
