look into the user_XXXX tables available to you in the data dictionary, in
your case USER_TAB_COLUMNS is the table you wish to enquire upon.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"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 - 08:51:59 CDT
