Re: retrieve columns information

From: Haber Schabernackel <schabernackel_at_hotmail.com>
Date: Mon, 23 Jul 2001 02:38:08 GMT
Message-ID: <1106_995856274@f3bpc14>

On Fri, 20 Jul 2001 17:53:27 +0200, "Jean" <ken_jean_at_hotmail.com> wrote:
> Hi to all!!
> I need to retrieve columns information from an Oracle 8i database.
> How can I do? I need tables structure such as Column name,
> column data type, column lenght etc etc. I tried to use
> User_MD_Columns but I haven't results.

Log in with sqlplus. And run 'desc tablename' to see the coloumns of a table. Try 'desc user_tables' or 'desc user_tab_columns' to see the meta-tables containing info on tables and coloumns. Received on Sun Jul 22 2001 - 21:38:08 CDT