Re: How to get column name from table ?

SELECT table_name, column_name FROM user_tab_columns WHERE ......... ;

Larry Johnson
KeepItSimpleEngineering,Inc.
http://www.kise-inc.com/

"Haplo" <Andrzej.Siedy_at_shh.pl> wrote in message news:9nvli1$hr0$1_at_news.tpi.pl...
> I have diffrent table with diffrent column names. How to get all column
name
> if I know name table_name. I must do something like: for all columns i
some
> of tables set NULL when <condition>
>
> I'v got tables from:
> select table_name from cat; <-- it's all what I need to get table_name
which
> interesed me.
>
> Thanks.....
Received on Sat Sep 15 2001 - 18:29:11 CEST