Re: Select * and column names

select table_name, column_name
from all_tab_columns
order by table_name, column_position

Refer to select * from dict for a description of all the dictionary views.

Hth,

Sybrand Bakker, Oracle DBA

"Talar" <talar_at_deja.com> wrote in message news:mFji5.79720$ou1.422681_at_nlnews00.chello.com...
> Hi,
>
> Unfortunately my knowledge of SQL is a bit limited at the moment.
> Nevertheless I'm in the process of writing an SQL parser that will pass
 the
> query on to an Oracle dbms by means of an external dll.
> Most of the things turn out okay, but i need to get the column names when
 a
> query-string like "select * from foo" is passed.
> A bit like SQL plus is doing if you run the above statement on table Foo.
>
> Does anyone know of a SQL statement to retrieve the column-names?
>
> thanks,
>
> Wil
>
Received on Thu Aug 03 2000 - 00:00:00 CDT