Comment maintenance tool?
From: Dr. John B. Matthews <jmatthews_at_nova.wright.edu>
Date: 1996/12/04
Message-ID: <1996Dec4.161315_at_nova.wright.edu>#1/1
John B. Matthews, M.D.
jmatthews_at_nova.wright.edu, john_matthews_at_ccmail.dayton.saic.com "Whom the gods would destroy, they first invite to program in C" Received on Wed Dec 04 1996 - 00:00:00 CET
Date: 1996/12/04
Message-ID: <1996Dec4.161315_at_nova.wright.edu>#1/1
Can anyone recommend a tool for maintaining comments in the schema? I can use COMMENT ON to establish or modify the comments, and I've written a little SQL*Plus script to generate a report based on the views user_tab_comments, user_tab_columns, and user_col_comments. But I wanted something more interactive.
Foolishly, I thought to create a modest form to edit the comments, but of course, one can't update a view:-) I can create a complicated form that accepts edits and spits out the relevant COMMENT ON command, but that seems round-about. Alternatively, I could maintain my own comment tables, but that seems redundant.
Is there an easier/better way?
John
John B. Matthews, M.D.
jmatthews_at_nova.wright.edu, john_matthews_at_ccmail.dayton.saic.com "Whom the gods would destroy, they first invite to program in C" Received on Wed Dec 04 1996 - 00:00:00 CET