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!

Issue with using sequence in INSERT statement

Mohammed RafiMay 18 2023

Hi,

I have created sequence named employee_seq which is used in the insert statement say employee_seq.nextval.

Assume that nextval is 100 and when two users are trying to use them in the insert statement it inserts with 100

How this situation can be avoided

Thanks
Comments
Post Details
Added on May 18 2023
#pl-sql
3 comments
436 views