Re: A query that returns table structure in PL/SQL

Try

select * from user_tab_columns
where table_name='your_table_name'

--
Grigor Coric /grigor.coric_at_lijanovici.com/ Zagreb, Croatia

goworej wrote in message ...
>Hi,
>I would like to write a short code in PL/SQL that would return me list of
>column names in a table.
>I know how to find the table name but I know no query that would perform
the
>same action as " desc table_name" in SQL Plus.
>Could you help me?
>Thanks
>Justyna Goworek
>justyna.goworek_at_carligry.com.pl
>
>
Received on Mon Jan 17 2000 - 08:52:59 CST