User Sequence Numbers

From: Hermann Angstl <hal_at_camline.com>
Date: Fri, 31 Jan 2003 10:31:16 +0100
Message-ID: <3E3A4264.8794D18A@camline.com>

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 Received on Fri Jan 31 2003 - 03:31:16 CST