Re: How to generate alpha-numeric sequence in Oracle?

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 31 Oct 2006 13:09:11 -0800
Message-ID: <1162328951.135982.324060@h48g2000cwc.googlegroups.com>

I can think of a couple of options, but it would help a lot to understand what are your expectations... Are you looking for a solution that will support multiple (1000?) concurrent users ?
Do you care about performance for insert/creates ? Can the solution tolerate holes in the alpha component. Can the solution tolerate holes in the numeric part.

Sorry for asking so many questions, but if we understood better the business requirements are you trying to satisfy, the better the solution.

The obvious answer is don't do it - make it a numeric field only. Otherwise,
have you considered creating two columns / is it an option ? have you considered precreating a table with all valid values with a 'available/used' flag

hth Received on Tue Oct 31 2006 - 15:09:11 CST