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

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1098552744.731435_at_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)

keeping in mind that, although an interesting feature, ORA_ROWSCN is not a solution to the OP's issue

++ mcs Received on Sun Oct 24 2004 - 08:04:57 CDT