Re: simple reverse engineering of schema using table and column comments

This would be fairly easy to do your self with some basic data dictionary queries, sqlplus and 'SET MARKUP HTML ON'.

HTH Jared

On Mon, 15 Nov 2004 23:00:57 -0800, Marc Slemko <identd_at_gmail.com> wrote:
> Does anyone have any pointers to any tools that can take a schema with
> comments (added by "comment on", visible in "user_col_comments", etc.)
> and reverse engineer it into a simple document describing table and
> column types, constraints and comments, etc.?
>
> I'm not really looking for a full blown modelling tool (although
> references to ones that can create or reverse engineer descriptions
> from Oracle comments would still be useful), but rather something more
> along the lines of some scripts that spit out HTML or some such.
>
> I'm trying to put together a small incremental step beyond the "well,
> here is the DML used to create the tables, that is all the
> documentation there is" level of data modelling without requiring much
> effort or requiring tools for developers to maintain it beyond a text
> editor. Using Oracle's comment for descriptive information on tables
> and columns seems like a potentially reasonable first step.
>
> Thanks for any suggestions.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l