O'Reilly logo

Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF by Duncan Mills, Peter Koletzke

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hands-on Practice: Load Audit Columns Using a Database Procedure and Application Context

A common requirement for database designs is to record the name of the user who created the record, as well as the name of the user who last modified the record, in separate columns (CREATED_BY and MODIFIED_BY, respectively) in each table. In addition, the creation date and last modified date are stored in two more columns (CREATED_DATE and MODIFIED_DATE, respectively). Although this information does not provide a complete history of the record, it helps track some of the activity. For a complete history, you would create a journal table for each table that requires operation-level audits. This journal table would store details about every INSERT, UPDATE, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required