Newsgroups: comp.databases.oracle.misc Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!wn14feed!worldnet.att.net!128.230.129.106!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: How to know size of a SQL query X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <3F097201.EFD16C59@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: Mime-Version: 1.0 Date: Mon, 7 Jul 2003 13:13:37 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 40 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129094 Have you queried *_TAB_COLUMNS (where * is DBA, ALL, or USER)? It will give you the information you seek. HTH, Brian Thomas Kellerer wrote: > > thibaut neiger schrieb: > > Hello > > > > I'd like to know the datatype of all columns of a SQL query. For instance, > > for the query : "select NAME, PHONENUMBER from PEOPLE", I'd like to get the > > type of NAME and the type of PHONENUMBER (varchar and number, in my > > sample). > > > > I can do this by doing a "desc PEOPLE". It will work in my sample, but not > > with a more complexe query like "select NAME, JOBNAME from JOBS j, PEOPLE p > > where p.JOBID = j.JOBID". How to get the size of NAME and JOBNAME ? > > > > I need this in order to create a generic window that can show results of > > any given query. > > > In which language are you developing your application? > > In Java you can retrieve this information from the ResultSetMetaData object. > > Thomas -- =================================================================== Brian Peasland oracle_dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"