Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using CoCreateGuid (Unique ID gen) in ORACLE - How can it be?

Using CoCreateGuid (Unique ID gen) in ORACLE - How can it be?

From: Alan Hopkins <ahop_at_CYBERIA.COM>
Date: Mon, 10 Jan 2000 11:20:46 -0500
Message-ID: <85d0tn$5n2$1@bob.news.rcn.net> 






Using the Microsoft  API to generate 128 bit unique ids (positive integer)
yields a number that has from 1 to 39 significant digits to the left of
decimal.



A NUMBER datatype in ORACLE can only be 38.... What am I missing?



I could use a VARCHAR(16), but the front-end application would incur some
additional overhead (hashing the string) and plus, it's going to take up
more memory.



Again, what am I missing in this picture?


Received on Mon Jan 10 2000 - 10:20:46 CST












Original text of this message













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