Skip to Main Content

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 do I identify the sequence of insertions in a table based upon timestamp(6)

User_W7P7OAug 11 2021

I have a table that uses the datatype timestamp(6) on a column. There are multiple inserts coming in at the same time via webservice calls to the millisecond. I added a column to the table, created a sequence and a before insert trigger which is assigning numeric values randomly.
There must be another way to do this. Any assistance would be greatly appreciated!!!!

Comments
Post Details
Added on Aug 11 2021
2 comments
410 views