Re: User Sequence Numbers

Hermann Angstl wrote:

> Hi,
>
> let's create the following table:
>
> create table foo (k number(5)); -- dont add primary key on k --
> insert into foo values (1);
> insert into foo values (2);
> insert into foo values (3);
> commit;
>
> Is it possible, with the following statement, to create unique numbers ?
> Even with multiple sessions ?
>
> select k from foo where k in (select max(k) from foo) for update of k;
> k++;
> insert into foo values (new_k);
> commit;
>
> ... is there another solution ?
>
> cu,
> hal

CREATE SEQUENCE foo_seq START WITH 1;

INSERT INTO foo VALUES (foo_seq.NEXTVAL);

Daniel Morgan Received on Fri Jan 31 2003 - 10:51:53 CST