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.

thanks you

Neiger Thibaut

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