3 Replies Latest reply: Feb 12, 2014 9:09 AM by 9ab3256b-d8ca-4a0a-9a9a-e37d01668fe6 RSS

    How to show changed records and values

    9ab3256b-d8ca-4a0a-9a9a-e37d01668fe6

      Hi,

      I have a requirement to show changed history for tables in my application. All tables have last modified date and last modified user.  What's the best way to do this? For example:

       

      EMP table (before)

      Name     phone                 mgr    

      Bob          555-1212          John

       

      EMP table (after)

      Name     phone                 mgr    

      Bob          555-1213          John

       

      Apex display

      Bob          555-1212          John

      Bob          555-1213          John

       

      I'm using OracleXE.

       

      Thanks