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

Home -> Community -> Usenet -> c.d.o.server -> Re: table changes - how to notice?

Re: table changes - how to notice?

From: Helma <bad_elefant_at_hotmail.com>
Date: Tue, 14 Aug 2007 04:50:47 -0700
Message-ID: <1187092247.845413.297920@o61g2000hsh.googlegroups.com>


On Aug 14, 1:37 pm, ciapecki <ciape..._at_gmail.com> wrote:
> Hi
>
> What is the most reliable way to check if the table changed?
> I could take the rows number, but it could happen that some rows got
> only updated, and the count of rows is the same, although table
> changed.
>
> Thanks
> chris

I assume that you mean if the data in the table has changed, not the table itself. Check the AUDIT command in your manual. Received on Tue Aug 14 2007 - 06:50:47 CDT

Original text of this message

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