Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL question - list column names?
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