-----Original Message----- From: Powell, Mark D Sent: Tuesday, November 23, 2004 5:21 PM To: 'thump@xxxxxxxxxxxxxxxx' Subject: RE: trigger question A working audit/history record trigger can be found in the article Is there a way to get the Date/Time when a row was last updated? at http://www.jlcomp.demon.co.uk/faq/mod_time.html The article can probably use updating but the example is fine. HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Sent: Tuesday, November 23, 2004 2:11 PM To: oracle-l@xxxxxxxxxxxxx Subject: trigger question How can I create a trigger that backs up the row that is updated on a table to a backup table pleasE? -- .. David -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l