Re: List of field of a given table

Two ways to do this.

1. Desc table_name
2. If you need the data in a program

Select column_name
from all_tabl_columns
where name = 'TABLE_NAME';

Marc Parkinson

"Diego Balgera" <diego.balgera_at_nokia.com> wrote in message news:YdUr9.17383$ZE1.373595_at_news1.nokia.com...
> A question from a very unexperienced user ...
> Could you please tell me how to list with sql the list of the fields,
given
> a table name, in Oracle 7.x?
> Thank you in advance.
> D.
>
>
Received on Fri Oct 18 2002 - 19:15:58 CDT