/ddl_history_pkg

Take object backups before updating PLSQL code

Primary LanguagePLSQL

DDL_HISTORY_PKG

Take object backups before updating PLSQL code

Take object backups before updating PLSQL code. Taking a backup before making changes to a database can provide several benefits, including:

Recovery in case of errors. Protection against data loss. Confidence in changes

To retrieve historical records from the ddl_history table, simply query the table.

Example