Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: last modification on row

Re: last modification on row

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 15 Jul 2005 20:46:59 -0700
Message-ID: <1121485621.343785@yasure>


Dave wrote:

> "Ike" <rxv_at_hotmail.com> wrote in message 
> news:3wRBe.5403$BK1.3879_at_newsread3.news.pas.earthlink.net...
> 

>>Is there a way to discern when the last modification (update or insert)
>>has
>>been performed on a row in a table? I have to work with a pre-existing
>>table
>>structure, and cannot alter it. Thanks, Ike
>>
>>
> 
> 
> log miner 

Or with 10g with an active Flashback area ... a flashback query.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Jul 15 2005 - 22:46:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US