Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!newsfeed.direct.ca!look.ca!news.noc.cabal.int!resurrector!guidorepost!not-for-mail From: "Ranga Chakravarthi" Subject: REPOST: Re: how to retrieve column names, column type, given the table name in a dynamic environment? Newsgroups: comp.databases.oracle.misc X-Repost-Date: 2 Jan 2002 22:59:25 GMT Message-ID: <4$--$$-$-_%$$-$__$@news.noc.cabal.int> X-Original-Path: sn-us!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed1.cidera.com!Cidera!cyclone.tampabay.rr.com!news-post.tampabay.rr.com!typhoon.tampabay.rr.com.POSTED!not-for-mail X-Original-Message-ID: X-Original-NNTP-Posting-Host: 65.35.116.8 References: <42bb2f93.0201011623.368fb6f@posting.google.com> X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Date: Wed, 02 Jan 2002 00:48:16 GMT 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 Sender: resurrector@mindspring.com (Guido the Resurrector) X-Reposted-By: resurrector@mindspring.com (Guido the Resurrector) X-Comments: GtR Repost: The following Usenet article was cancelled, more X-Comments: than likely by someone other than the original poster. Please X-Comments: see the end of this posting for a copy of the cancel. X-Comments: Guido the Resurrector can be contacted at X-Comments: resurrector@mindspring.com. Lines: 43 Xref: easynews comp.databases.oracle.misc:74375 X-Received-Date: Thu, 03 Jan 2002 09:51:03 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 > ========= WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!news-koe1.dfn.de!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!news2.euro.net!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Ranga Chakravarthi" Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.misc Subject: cmsg cancel Control: cancel Date: Wed, 2 Jan 2002 02:52:08 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009943264 19888 166.102.15.34 (2 Jan 2002 03:47:44 GMT) X-Complaints-To: abuse@navix.net NNTP-Posting-Date: 2 Jan 2002 03:47:44 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40276084 autocancel