SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to generate 6 digit random number for employee id?

14137Nov 5 2003 — edited Nov 6 2003

Hi all,

What is the best way to generate a 6 digit random number for employee id (primary key)? I don't want to use sequance for this purposes. I know that there is dbms_random but it produces 8 byte integer number.

Thanks for your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2003

Added on Nov 5 2003

6 comments

6,346 views