Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to generate alpha-numeric sequence in Oracle?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US