Re: Create unique sequence
Date: Tue, 11 Dec 2001 18:57:59 GMT
Message-ID: <XGsR7.36610$Yy.389990_at_rwcrnsc53>
Create a function that takes a number and returns the sequence. I'll do it
for $, probably less than 30 minutes work.
Jim
"liu" <cissyliu_at_hotmail.com> wrote in message
news:2829b61c.0112110959.74d1cc96_at_posting.google.com...
> Hi, all
> Does anyone know how to create a unique oracle sequence like this
> generate sequence in Oracle as follows?
>
> abc2000
> abc2002
> abc2004
> abc2006
> 2008abc
> 2010abc
> 2012abc
> 2014abc
> .
> .
> .
> The number part will start with 2000, incremented by 2. When the
> sequence reaches 2006, then the sequence reverses the order with text
> string abc in the back followed the number part. Can anyone help me
> come up with an solution. Thanks a lot!
>
> Liu
Received on Tue Dec 11 2001 - 19:57:59 CET