Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to generate alpha-numeric sequence in Oracle?
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