Create unique sequence

From: liu <cissyliu_at_hotmail.com>
Date: 11 Dec 2001 09:59:55 -0800
Message-ID: <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 - 18:59:55 CET

Original text of this message