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