SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Row Modified date

317179Mar 18 2003 — edited Mar 18 2003

I am wondering if akin to ROWNUM, there is some pseudo-column i can select with my records to get the last time that the data in the row was physically updated in Oracle, to allow me to eliminate the need for a MODIFIED column and associated triggers or insert/update columns in my own code...

something like
SELECT MYCOL1, MYCOL2, MYCOL3, <ROWUPDATE> FROM MYTABLE

Where ROWUPDATE is the hypothetical pseudo-column.
Does this exist? Thanks in advance - Aaron.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2003

Added on Mar 18 2003

6 comments

1,164 views