Re: Custom Sequence Generator
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 15 Oct 2014 19:04:52 -0400
Message-ID: <CAGurbTNZiwZz+0cog4YZpYZMnjFMYk9rPCr8z4cmXxwo_bgxGQ_at_mail.gmail.com>
Try
http://oraqa.com/2008/04/19/how-to-convert-number-from-any-base-to-any-other-bases-in-sql/
Date: Wed, 15 Oct 2014 19:04:52 -0400
Message-ID: <CAGurbTNZiwZz+0cog4YZpYZMnjFMYk9rPCr8z4cmXxwo_bgxGQ_at_mail.gmail.com>
Try
http://oraqa.com/2008/04/19/how-to-convert-number-from-any-base-to-any-other-bases-in-sql/
I used this idea to generate a 32 digit unique number (used 0-9A-Z minus vowels to avoid *naughty* words), works well. Note I am not saying it will scale well, but works well.
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 16 2014 - 01:04:52 CEST