documenting datadictionary

[zulu99]

Hi

tell me if this possible.

i want to create a excel document which will list me contents in somewhat this manner

say
for a particular
table_name
it gives me its corresponding
column_names, indexes, constraints, triggers, defaultvalues of columns
packages, procedures, functions, grants

Regards
Sushant

[agasimani]

I wish life was this easy..... But I am afraid you will have to write your own scripts.

If anyone knows better way to do it, please share the information here.

[SANJAY_G]

Not sure of Excel but OEM and other GUI Admin tools can provide all this info.

[hrishy]

Hi

You can write a ref cursors in a pl/sql stored proceedure where you input the table and the result set would contain what you require..then using odbc and excel i think you can do this...

This is my idea although i dont have much experience with ODBC..but u get the idea..

regards
Hrishy

[lynn814]

Well you could write a query to get you all that info, spool it to a text (.txt) file and then import that file into Excel.
I have done this quite a few times and works really well.

HTH,
Lynn