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: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 29 Nov 2006 18:23:50 +0100
Message-ID: <4t5u11F121qlpU1@mid.individual.net>


On 29.11.2006 16:09, kranilk_at_gmail.com wrote:
> As regarding the justification for the business case, the client is
> saying they have always used this type of sequence and they want our
> system (which they just bought now) to be capable of generating this
> sequence. As far as performance goes, our client says that at most they
> might use about 5 sequences a month.

"sequences" or "individual values"?

I would go with Brian's suggestion - that roughly the same thing that I would have suggested. An alternative might be to create a view that does the conversion on the fly but if you have dependent tables things can get messy (and slow) soon.

Kind regards

        robert Received on Wed Nov 29 2006 - 11:23:50 CST

Original text of this message

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