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: Challenge: algorithm to transform unique string into unique number

Re: Challenge: algorithm to transform unique string into unique number

From: Alan <alan_remove_this_shein_at_erols.com>
Date: Fri, 23 Aug 2002 16:11:16 -0400
Message-ID: <ak64lp$1fhm3p$1@ID-114862.news.dfncis.de>


Is this homework, or for a final exam?

"upuaut" <upuaut_at_yahoo.com> wrote in message news:c1a86e59.0208231013.7608106a_at_posting.google.com...
> Group A (we) has a database with few tables that maintains
> demographics and survey responses of a list of users. A user is
> identified by their (type text) user_id . Each of course have their
> own unique one.
>
> The challenge: We (group A) need to feed out survey data into a nother
> database maintained by group B (them) that uses a number as a unique
> identifier for the user_id. Is there a way I can generate a *MAGICAL*
> unique number for every user from the user_id?
>
> Also, we should be able to get the user_id from the generated number.
>
> The login ID is varchar2(100)
> The number to be generated is Number(20)
>
> Any help/pointers is/are appreciated.
>
> thanks.
Received on Fri Aug 23 2002 - 15:11:16 CDT

Original text of this message

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