I want to add two columns to all my tables [Create Time] & [Modify Time] to capture audit trail .In the future these fields might be used in partitioning the table. Please suggest on what is the best approach of doing this ? Is it wise to do it through some triggers at DB or to update these values through code. We are using Hibernate APIs to talk to Oracle 11g.