2 Replies Latest reply: Feb 2, 2013 10:19 AM by 852736 RSS

    Audit Table

      Hi All,

      I have a table called Program_info with the following columns. program_id, program number, program name, program details, program_month_date. I have to maintain a audit table, whenever any changes happen to Program_info I need to capture the changes in teh audit table, please give me some ideas on how to accopmplish it, with any audit table logics.

      Thanks for your time and help.
        • 1. Re: Audit Table
          Taking a look at the big picture first might help http://docs.oracle.com/cd/E11882_01/server.112/e25789/cmntopc.htm#CNCPT89153



          Edited by: Etbin on 2.2.2013 17:09
          some further reading http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:59412348055 in case everything seems too complex.
          • 2. Re: Audit Table
            Create program_info_audit table and then you can have a before insert/update/delete triggr program_info table.