Re: UID generation in oracle - how?

John Mullee wrote in message <36E34DFA.C5199332_at_exmachina.net>...
>I've 77.4MB of PDF's to search through for this -
>surely it's been done before!
>How does one normally generate a unique ID?
>Is there a datatype that autoincrements itself?

CREATE SEQUENCE my_seq;
INSERT INTO foo
my_seq.nextval;

Blair Received on Mon Mar 08 1999 - 00:00:00 CET