About insertion information in oracle table

[ripon32]

How can I obtain information about insertion time of a row in a oracle table?? The table has no "Date" column.

[davey23uk]

you cant really

[LKBrwn_DBA]

An aproximation would be to query: SCN_TO_TIMESTAMP(ORA_ROWSCN) pseudocolumn.

[Kamran Agayev]

Hi
May be it's the only solution but you should mention that it is not useful for transactions in which you insert more than one row. It will be recorded as one SCN number
For example, you can look to Laurents example shown here:
http://laurentschneider.com/wordpres...last-rows.html

[LKBrwn_DBA]

Hi
May be it's the only solution but you should mention that it is not useful for transactions in which you insert more than one row. It will be recorded as one SCN number
For example, you can look to Laurents example shown here:
http://laurentschneider.com/wordpres...last-rows.html

Yes, but a) I said it's an approximation and b) he's looking for a TIMESTAMP.

[Kamran Agayev]

Yes, you're right
It should be a solution in this situation