Re: How to know size of a SQL query

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_at_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"