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