How to generate a unique ID?

[Bala Krishniah]

I my java class, I am using JDBC to connect to the dtatabase.
Everytime I insert a recod, I wan to nenerate a unique id and add that id in the parimary_key column. How do I generate a unique id.
Thanks for your help!!

[ali pak]

hi,
why not you try, this ,
1. import java.util.Random
2. create a Random class object
3. and use nextInt() instance method to generate a integer number.
4. Concatenate it with primary key and before inserting into table, check whether this key already exist in table , if yes, repeat step 3 again.
ali

[SJ Adnams]

use a sequence
------------------
http://www.x-nt.com

[Beksy Kurian]

create a sequence in the database named someseq. Then in your program, add this
select someseq.nextval from dual
or
just 'someseq.nextval'(primary key field) in the insert statement
and add this value along with other column values.
Regards
Beksy

[Bala Krishniah]

I created a Sequence, in the datadase.
Its name is SEQ_UUID
In my java code when I write the following code:
String uuid = SELECT SEQ_UUID.currval FROM dual;
Its is giving a error message saying: Expected ';'after the above line of code.
Also I want to append the sysdate to able generated 'uuid' in the MMDDYYYYHH24MISS formate. How do I alter the default value of the sysdate.
Thanks for your help in advance!!

[SJ Adnams]

INSERT INTO FOO (X,Y,Z) VALUES (SEQ_UUID.NEXTVAL, 10, 20);
Unfortunaty Oracle doesn't let you have NEXTVAL in the default clause of your create table.
------------------
http://www.x-nt.com

[Daniel Dunleavy]

You can use TO_CHAR(sysdate, 'MMDDYYYYHH24MISS')