Re: number of columns in a table?

From: Bob Leonard <farsider_at_postoffice.ptd.net>
Date: 1996/08/22
Message-ID: <321bb811.0_at_downed.ptd.net>#1/1


You should be able to look into the user tables to determine the number, type, and order of columns in a table. 'user_columns' is probably the table name.

Bob
In article <3210E4A8.41C6_at_curagen.com>, cliang_at_curagen.com says...
>
>Hi,
>
>We would like to know if we can get information such as number of
>columns in a table from PL/SQL?
>
>Or if we can loop through dbms_sql.define_column to exhaust all the
>colomns?
>
>Any suggestion is appreciated.
>
>Charlene
>--
>
>Charlene Liang | (203) 481-1104 ext. 287
>CuraGen Corporation |
>322 E. Main St. |
>Branford, CT 06405 |
>cliang_at_curagen.com | (FAX) (203) 481-1102
Received on Thu Aug 22 1996 - 00:00:00 CEST

Original text of this message