-
documenting datadictionary
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
-
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.
Agasimani
OCP(10g/9i/8i/8)
-
Not sure of Excel but OEM and other GUI Admin tools can provide all this info.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|