From Rivaldi.Behar@ilonafinancial.com Thu, 10 May 2001 10:33:27 -0700 From: "Behar, Rivaldi" Date: Thu, 10 May 2001 10:33:27 -0700 Subject: RE: Table last updated data Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Table last updated data Turn audit on and then audit on update on that table. Rivaldi -----Original Message----- From: James Stein [mailto:jstein@neom.com] Sent: Thursday, May 10, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Subject: Table last updated data Does Oracle capture a last updated date whenever a table update occurs? Or do I need to create a trigger to handle this? Thanks... D. James Stein Senior Developer/Database Engineer jstein@neom.com 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 x165 Cell: 941-633-4698 Fax: 941-337-1605 www.neom.com www.paperclick.com www.qode.com          -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Stein   INET: jstein@neom.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).