Re: Is there any built-in timestamp per row?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/12
Message-ID: <qth9fskclag4b8hqchlpkg05tr895casfh@4ax.com>#1/1

On Wed, 12 Apr 2000 11:39:41 -0700, Young Lee <young.lee_at_supplysolution.com> wrote:

>
>Is there any hidden/pseudo column in a table which indicates when this
>row is inserted or updated last time?
>
>Thanks,
>Young Lee

No, but you can easily add a column and do that per trigger. The only thing you need to do is
:new.date_modified = sysdate

and that's all.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Apr 12 2000 - 00:00:00 CDT

This message: [ Message body ]
Next message: thentzel_at_yahoo.com: "which storage solutions (xiotech,sun,emc) w/oracle?"
Previous message: Young Lee: "Is there any built-in timestamp per row?"
In reply to: Young Lee: "Is there any built-in timestamp per row?"

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