Sequence question, need to prefix the sequence with a 4 digit incrementing
621865Feb 6 2008 — edited Feb 7 2008number. I have a business process which i need to replicate such that I can count up to 999,999 and then roll over to 0.
The data range would go something like this:
1000 0:999999 1000000000 ... 1000999999 then rolls over to
2000 0:999999 2000000000 ... 2000999999
3000 0:999999 3000000000 ... 3000999999
4000 0:999999 4000000000 ... 4000999999
My background is in design and as a java developer. To me this sequence assignation process shouldn't be done in java and should stay in Oracle's memory space. I'm thinking this is possible just wanted to pass it on a sanity test.
Thanks,
David