Oracle Table Header as output

[mediator]

Hi,

 

 I have a database with many tables. I need to get an output where table header information is also collected. e.g

 

Facts

DB - masterdb

tables -> table1,table2,table3.....table10

 

Format of tables :

• table1 -> name, place, animal, thing
• table2 -> nameid,placeid,animalid,thingid
• table3 -> name,nameid
• .
• .
• table10

Problem Statement

 

I need to get a format like below

 

S.No    Tablename     table_header_information

1          table1            name, place, animal, thing

2          table2            nameid,placeid,animalid,thingid

3          table3            name,nameid

.

.

10        table10          etcetcetc

 

 

How can this be done? I need table header information, if possible, in the above format.

 

Thanx :)

 

 

[+Fahim S. MVC]

What have you tried so far? What language?