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: Timestamp of a record

Re: Timestamp of a record

From: NoName <nobody_at_nowhere.com>
Date: Thu, 11 Dec 2003 14:51:34 +0100
Message-ID: <br9s2l$no0$1@fata.cs.interbusiness.it>


> to be absolutely sure you're always getting the real time, populate the
> field with a trigger (which is also the way to track time of last update)

that's true, thank you for your suggestion. Too bad the row's timestamp is not stored somewhere in Oracle system tables. Maybe in future versions, only on request (since it could be a waste of time!) an option could be added.

For example, CREATE TABLE <tablename> ... TIMESTAMP ROW.

Do you think it could be useful?

> -- mcs

[Off Topic mode ON]
MCS is the acronym of a famous character in Italy, it stands for "Maurizio Costanzo Show", an italian format of the most famous "David Letterman Show"... nothing to do with Oracle, but it makes me smile :-) [Off Topic mode OFF]

Thank you and Regards Received on Thu Dec 11 2003 - 07:51:34 CST

Original text of this message

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