Re: how to retrieve column names, column type, given the table name in a dynamic environment?

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to retrieve column names, column type, given the table name in a dynamic environment?

From: Ranga Chakravarthi <ranga_at_cfl.rr.com>
Date: Wed, 02 Jan 2002 00:48:16 GMT
Message-ID: <kNsY7.239079$oj3.42093216@typhoon.tampabay.rr.com>

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
>
Received on Tue Jan 01 2002 - 18:48:16 CST