Re: Is there a way to find a timestamp of a row

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 21 Oct 2004 17:51:18 -0400
Message-ID: <ZYqdnderkZbusuXcRVn-gw@comcast.com>

"Prem K Mehrotra" <premmehrotra_at_hotmail.com> wrote in message news:43441e77.0410211201.77414e1d_at_posting.google.com...
| When I look in any of my tabls in Oracle database, I can get rowid for
| each
| row, but is there a way to find the time when that row was created. I
| don't want to store cretaion time of a row as a column in my table.
| Does Oracle internally keep this information some where, if yes how to
| access this time information?
|
| Thanks,
| Prem

you must add the appropriate columns to your tables and create the appropriate triggers to populate them

++ mcs Received on Thu Oct 21 2004 - 16:51:18 CDT