Describing Tables in PLSQL

[Que]

Hello Everyone,

Here is what I want to do:

I want to write a procedure that when executed will display all the names of the columns for me for all my tables.

So, I thought I would declare a cursor that returns the object names for my tables; something like:
select object_name
from user_objects
where object_type = 'TABLE';
How can i dbms_output the column names for each table; something similar to what
'describe table_name' would do?

Thank you everyone in advance
Que

[hrishy]

hi

Look at user_tab_columns

regards
Hrishy

[Que]

Thanx Hrishy