Re: How to know size of a SQL query

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Fri, 04 Jul 2003 12:31:33 +0200
Message-ID: <be3l26$tli1$1@ID-13919.news.dfncis.de>

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 Received on Fri Jul 04 2003 - 05:31:33 CDT