Re: How to get the field attributes from a table

Hi.
You can use "Describe" command in SQL*Plus. Also, You can use "User_TAB_Columns" dictionary.

Bye~~
Young-chul Jun ycjun_at_hotmail.com
Samsung SDS

Small Keung ÀÌ(°¡) <71r8u1$cgb_at_eng-ser1.erg.cuhk.edu.hk> ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>As I created a table from Oracle database, how can I get the field
attributes (e.g. Field name, length, types) by SQL commands?
>
>--
>By ¤p±j¤p±j¤p¤p±j
>¤W¤W¤U¤U¥ª¥ª¥k¥k...
Received on Thu Nov 05 1998 - 00:09:42 CST