Using DDL trigger to call the DBMS_METADATA package to get source code of object, or use Oracle Dictionary
Versions Compare between versions
Use DIFF java class, deployed as Stored Procedure
Developed by Stuart D Garthman
API to query the objects versions are just SQL queries, pipeline function, etc to return the differences
- could use APEX front end
DDL triggers are a bit risky, use appropriate error handling
[Author note: formating is crappy here because my laptop ran out of battery. Need to charge. Also, not the best presntation]
Comments
Post a Comment