Re: Timestamp of a record

"NoName" <nobody_at_nowhere.com> wrote...
> > 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?

Hi NoName (arrgh!),
not as long as this information goes into a system table. That would mean a join whenever you want to query this data. So: I'd prefer storing it in the original table. And that (as you know) can be done even today.

Just my $ .02

Greetings,
Guido

PS: what about using your real name? Or are you on the Italian Most Wanted list? ;-) Received on Thu Dec 11 2003 - 08:26:20 CST