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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 23 Oct 2004 10:33:19 -0700
Message-ID: <1098552744.731435@yasure>

Connor McDonald wrote:

> Prem K Mehrotra wrote:
>

>>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

>
>
> ora_rowscn in v10 gives the scn which can be mapped relatively closely
> to a time of day.
>
> hth
> connor

For those interested a demo of ORA_ROWSCN can be found at http://www.psoug.org. Click on Morgan's Library. Click on Pseudocolumns.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sat Oct 23 2004 - 12:33:19 CDT