I am adding comments to columns in data dictionary within existing tables.
I have few questions,
Is COMMENT command considered as a DDL statement in Oracle?
If we add comments on columns using sql statement (COMMENT on column table_name.field_name IS 'your comment...') then can we keep history table and respective trigger to add entry to that history table to keep timestamp when comment was added to column?
Kindly please let me know can we explore 2nd option and maintain history for columns comments changes in data dictionary..
Thank you,
Akshay Jadhav