Re: SQL question - list column names?

just fyi...

"desc" is NOT an SQL statement.
it is a SQL*Plus command.

the SQL statement to list the names
of the columns for a table would be
something like this:

select column_name
from all_tab_columns
where owner = '<owner>'
and table_name = '<table_name>'

-or this:

select column_name
from user_tab_columns
where table_name = '<table_name>'

(note: the user must have select
privilege on the dictionary view)

"pox" <pox_at_pox.com> wrote in message
news: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 Mon Apr 24 2000 - 00:00:00 CDT