Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to update a table with the time of insert instead of time of commit

848501Aug 29 2012 — edited Aug 30 2012
dear,

i have 10 record at source side which needs to be injected in a target table ;
the record creation date is injected with the systimestamp -

when commiting it takes for all the same timestamp for all records( at commit time ) however I would like to insert the timestamp at INSERT moment to have a unique timestamp - id est at INSERT time.

Can anyone please adviseN?

Thanks

Erik

Edited by: 845498 on 29-aug-2012 1:36
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2012
Added on Aug 29 2012
4 comments
450 views