Re: How can i find out the column name from a table by issuing a select query?
From: raghu <raghu1ra_at_rediffmail.com>
Date: 12 Jan 2002 09:41:32 -0800
Message-ID: <d11b9387.0201120941.2ffbeea0_at_posting.google.com>
Date: 12 Jan 2002 09:41:32 -0800
Message-ID: <d11b9387.0201120941.2ffbeea0_at_posting.google.com>
sohelcsc_at_yahoo.com (Leader) 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
hi
use a select query on either of these two dictionary tables
DBA_TAB_COLUMNS or USER_TAB_COLUMNS
regards
Certified DBA
Raghu
Received on Sat Jan 12 2002 - 18:41:32 CET