190 pts.
 Oracle Data Dictionary
I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this information in such a way that I may incorporate it into an actual document?

Software/Hardware used:
ASKED: February 3, 2009  3:59 PM
UPDATED: February 18, 2009  7:48 PM

Answer Wiki:
This depends on what you mean by format and the content you are wanting. Using simple sqlplus, you can spool out table and index descriptions, as well as any trigger or stored procedure source code. This can be put into just about any documentation tool and made to look very professional. If you have it available, Oracle Reports can do even more formatting than straight sqlplus, but you have to know more to work with the tool. SQL*Plus can do any of the basic formatting and by pre-defining your queries and formatting statements and placing them in a script (unix, windows, whatever o/s), you can reuse this script to update your documentation for this and future contracts....... or you could always find a 3rd party tool to do it for you.
Last Wiki Answer Submitted:  February 18, 2009  7:48 pm  by  Jcmdba   555 pts.
All Answer Wiki Contributors:  Jcmdba   555 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _