Re: Display table columns

xo55ox wrote:

> Hi,
>
> I like to know beside using 'desc table_name' statement to show
> columns, is there any other way to retrieve table's column? Is there
> any system tables that store other tables' (user tables') columns?
>
> Thanks in advance.

Try user_tab_columns

eg.
select column_name,data_type,data_length,nullable,data_default from user_tab_columns
where table_name='<table_name>'; Received on Thu Jul 01 2004 - 16:49:10 CDT