Re: number of columns in a table?

Charlene Liang wrote:
>
> 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

Try

select count(*)
from user_tab_columns
where table_name = <your table name>;

Dave Roth Received on Fri Aug 16 1996 - 00:00:00 CEST