Re: Table last updated data

From: William Beilstein <BeilstWH_at_obg.com>
Date: Thu, 10 May 2001 09:21:07 -0700
Message-ID: <F001.002FF5E6.20010510080605@fatcity.com>

Trigger, Oracle doesn't maintain last update date for a table. I would put a last modify column in the table with a trigger to maintain it. then you could see when each row was inserted or modified and could tell when the table was last modified by using the following select SELECT MAX(LAST_MODIFY) FROM MY_TABLE;

>>> jstein_at_neom.com 05/10/01 11:21AM >>>
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_at_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_at_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_at_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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.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_at_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).

Received on Thu May 10 2001 - 11:21:07 CDT