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
