Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL question - list column names?

Re: SQL question - list column names?

From: kru <kru_at_messer.de>
Date: 2000/04/25
Message-ID: <8e40d4$eit$1@news.messer.de>#1/1

Hi pox,

try :
select * from dba_tab_columns ;
or :
select * from user_tab_columns;

which gives you plenty output. This will work in any case, describe table will just do if you are in SQLPLUS.

pox schrieb in Nachricht <8e2i2e$4bf$1_at_news.tdl.com>...
>hello all,
>
>is there an SQL command that would list all of the
>table's column names for me?
>
>thanks for any help,
>-steve
>
>
>
>
>
>
>
Received on Tue Apr 25 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US