General information
Category:
Coding, syntax & commands
Hello all
Need assistance urgently. I am looking for assistance in define an approach
for generating meaningless unique id's. Even though it is not listed as a
requirement, each id must be unique. The customer specification is below:
The individual student identifier itself will not include any coded
information, but will be constructed in such a way that its validity as an
identifier can be determined. One such approach would be to construct a
"nearly random" number as follows:
1. 10 digits, all numeric
2. 10th digit is a check digit
3. First digit is never zero
4. There are no occurrences of more than 2 repeating digits
5. Numbers will be assigned evenly spread across the range from
1,001,001,001 to 9,989,989,989"
Obviously we will only be generating the first 9 digits and then calculating
the 10th. I've attached a brief write-up on the check digit piece.
The application will be Java/Oracle. Is there any means to use Oracle's
Create Sequence or variations on that command to generate the id? I'm
looking for a brief write up on a viable approach.
Txs for any help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only