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>
Date: 11 Dec 2001 09:59:55 -0800
Message-ID: <2829b61c.0112110959.74d1cc96_at_posting.google.com>
Hi, all
abc2000
Does anyone know how to create a unique oracle sequence like this
generate sequence in Oracle as follows?
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