Re: When last changed?

From: Davide Bianchi <davidebianchi_at_davidebianchi.net>
Date: Thu, 6 Sep 2001 13:09:10 +0200
Message-ID: <9n7lh0$5qgo9$1@ID-18487.news.dfncis.de>

"Chris Neubauer" <water.world_at_gmx.de> wrote in message news:9n7kv2$5qqcj$1_at_ID-76747.news.dfncis.de...
> how can I find out when a table was changed (i.e.
> insert/update/delete) for the last time?

In short: you have to enable some sort of logging using triggers or stored procedure to store the timestamp each time a modification is performed on the table.

Davide Received on Thu Sep 06 2001 - 06:09:10 CDT

This message: [ Message body ]
Next message: C. R. Soza: "Re: Can this be optimized further?"
Previous message: Davide Bianchi: "Re: Oracle 8.1.7 JDBC"
In reply to: Chris Neubauer: "When last changed?"
Next in thread: Mark D Powell: "Re: When last changed?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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