Re: How can i find out the column name from a table by issuing a select query?

From: Greg Kainz <gregkainz_at_attbi.com>
Date: Sun, 13 Jan 2002 03:29:31 GMT
Message-ID: <va708.16563$uA.127991_at_rwcrnsc51.ops.asp.att.net>


"Greg Kainz" <gregkainz_at_attbi.com> wrote in message news:2A_%7.12639$Vq.81557_at_rwcrnsc53...
> "select column_name from user_tab_columns where table_name = '(table name
 of
> interest goes here)';
>
> "Leader" <sohelcsc_at_yahoo.com> wrote in message
> news:b1a93c73.0201120530.513d02f1_at_posting.google.com...
> > Hi all,
> > i am facing a problem that is i need to to know the all column names
 from
> > a table with a select statements. how can i do that.
> > remember i need to run the query from java.
> > in oracle i know that is desc table_name;
> > but i need to run the query from java.
> >
> > thanks
> > hoque
>
>
Received on Sun Jan 13 2002 - 04:29:31 CET

Original text of this message