Re: table fields

select COLUMN_NAME, DATA_TYPE from USER_TAB_COLUMNS where TABLE_NAME=UPPER('<Your table>');

"KADIVAR" <kadivar_at_aol.com> a écrit dans le message news: 20011013162328.21823.00001688_at_mb-fr.aol.com...
> Hello
> By which instruction can find the names of all fields of a table and their
data
> type ? Thank you very much.
Received on Sat Oct 13 2001 - 15:58:34 CDT