Home » RDBMS Server » Server Administration » last update
last update [message #371289] Thu, 28 September 2000 07:51 Go to next message
Thomas
Messages: 67
Registered: September 1999
Member
i want to know when the last data-update in a table
is it possible?
Re: last update [message #371290 is a reply to message #371289] Thu, 28 September 2000 08:01 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,

You can write a on update trigger for that table.
And insert a time stamp to a history table.

Bala
Previous Topic: Re: How to assign a default value to datatype number for the whole instance
Next Topic: 8i server and client on same system
Goto Forum:
  


Current Time: Sun Dec 22 11:24:03 CST 2024