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!

Function - Oracle Sequence & String Concatenation

189123May 29 2020 — edited May 30 2020

Hello,

For a heavily used transaction form, planning to create an Oracle Sequence for the primary key, sequence will be used in a function which will have a string concatenation to include year and alphabets. e.g. BG-2020-00001 (last part (00001 ) would be a sequence)

What are the points to consider for the function as the form is used by many users concurrently to deter the issue of primary key violation.

Appreciate insight and help.

Database version is 11g R2

Regards

This post has been answered by mathguy on May 29 2020
Jump to Answer
Comments
Post Details
Added on May 29 2020
9 comments
357 views