About insertion information in oracle table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: About insertion information in oracle table

  1. #1
    Join Date
    Apr 2009
    Posts
    1

    About insertion information in oracle table

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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you cant really

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Talking Ora_rowscn

    An aproximation would be to query: SCN_TO_TIMESTAMP(ORA_ROWSCN) pseudocolumn.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Feb 2009
    Location
    Azerbaijan, Baku
    Posts
    24

    Ora_rowscn

    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

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool Scn -> Timestamp

    Quote Originally Posted by Kamran Agayev View Post
    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.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  6. #6
    Join Date
    Feb 2009
    Location
    Azerbaijan, Baku
    Posts
    24
    Yes, you're right
    It should be a solution in this situation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width