Herein lies one of the problems of using third party tools such as TOAD. You all probably know I'm a fan of TOAD but you should be carefull about substituting TOAD knowledge with Oracle knowledge.
All TOAD does (in the comment situation) is the following....
Comment on table FRED IS 'This is the fred table';
Comment on column FRED.ID is 'This is Fred's ID column';
They're Oracle statements, ie, valid in SqlPlus or on any other tool that can push some text to an Oracle DB.
You can get this data by querying the system views (all_col_comments / all_tab_comments or somesuch).
A useful feature of TOAD is 'Spool SQL'. Unfortunately Quest software (TOAD's publishers) see fit to completely mess up the menu structure in between each and every version so I couldn't tell you where to find it.
TOAD is great - but learn how to do it in SqlPlus before relying on TOAD. That way, the 101 different AV's that TOAD generates won't bother you too much.
For the past two weeks I can mess with Oracle's serializable isolation (nasty), I could up and down instances quicker than a wh**es drawers, allsorts. I could post here, there and everywhere, (except not actually here).
This could be two in a row!
Yes, you're right, I'm sad for trying so hard. Now you poor sods will have to put up with my mumblings again :-)