Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> REPOST: Re: how to retrieve column names, column type, given the table name in a dynamic environment?
Karthik,
select column_name, data_type
from user_tab_columns
use all_tab_columns for all the tables you have privilege on and
dba_tab_columns for all the tables
in the database. when using these two views you can use the owner column to
differentiate
HTH,
Ranga Chakravarthi
"humble_one" <rastapoppolous_at_yahoo.com> wrote in message
news:42bb2f93.0201011623.368fb6f_at_posting.google.com...
> hi everyone,
> how can one retrieve column names, column type, given the table name
> in a dynamic environment?
> I am using oracle as the database, and PERL DBI.
>
> Thanks in advance,
> Karthik
>
autocancel Received on Tue Jan 01 2002 - 18:48:16 CST