Skip to main content

Storing Database Object versions in Oracle Database

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