Generate surogate key (number) dynamically
611558Nov 19 2009 — edited Nov 26 2009Hi,
I would to generate surogate key (based on Business key/keys which is/are varchar) dynmically other than oracle seq number and orahash (due to collision). The table might contains 1 billion of records and same key to be perculated among different others table. Can I have any procedure/function which will return unique number each time if I pass business varchar and there will eb no collision. eg If I pass 'ABS' it will give me same unique number each time when the funtion is called and different unique number for diffrenet imput. My input is varchar2 and length is 255. Any suggestion how to implement such function?