I would like to add comments on table columns ( and tables ) used in my Enterprise ApEx Application (for documentation, about 200 tables),
a)I would like to create a tabular form to edit table columns comments, but how? I think I can not implement it directly on data dictionary?
b) execute command for every column or Table => COMMENT ON TABLE myTable1 IS 'This is a table for .......' / COMMENT ON myTable.acolumn IS 'This columns is a for ........'
Do have anyone any good approach ?
select * from USER_COL_COMMENTS;
Hope it helps.