Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!feed2.news.rcn.net!rcn!dca6-feed2.news.digex.net!intermedia!newsfeed1.cidera.com!Cidera!cyclone.tampabay.rr.com!news-post.tampabay.rr.com!typhoon.tampabay.rr.com.POSTED!not-for-mail From: "Ranga Chakravarthi" Newsgroups: comp.databases.oracle.misc References: <42bb2f93.0201011623.368fb6f@posting.google.com> Subject: Re: how to retrieve column names, column type, given the table name in a dynamic environment? Lines: 25 X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Wed, 02 Jan 2002 00:48:16 GMT NNTP-Posting-Host: 65.35.116.8 X-Complaints-To: abuse@rr.com X-Trace: typhoon.tampabay.rr.com 1009932496 65.35.116.8 (Tue, 01 Jan 2002 19:48:16 EST) NNTP-Posting-Date: Tue, 01 Jan 2002 19:48:16 EST Organization: RoadRunner - Central Florida Xref: easynews comp.databases.oracle.misc:74297 X-Received-Date: Wed, 02 Jan 2002 02:43:36 MST (news.easynews.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" wrote in message news:42bb2f93.0201011623.368fb6f@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 >