Hi!
Why not use sequenses, as are usually used to create values for PK in Oracle database? Its much like Auto-number field in SQL Server, but you require to get the next sequense value BEFORE inserting of record.
HTH.
>Actually this code works but I'm not sure if it is still unique?
>
>SELECT TO_NUMBER(TRANSLATE(sys_guid(),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','00000000000000000000000000')) FROM DUAL;
>
>I suppose unique enough?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.