Skip to Main Content
Forums

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!

DBMS_RANDOM

LuKKaMar 17 2011 — edited Apr 5 2011
Dear All
I want to generate random passwords which contains total 6 characters and out of 6 , 3 are char and another 3 are number and all the password should not be same .
Like :- ABC123
BDF387
-------

So should i use DBMS_RANDOM packege OR any other way like , i will create a table which contains a column with the value let say 001 and i will take this no and use in my procedure like +1 .. ?

Which will be correct and best ?
If i have to use DBMS_RANDOM then kindly give me a small example ...

Thank you .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2011
Added on Mar 17 2011
#and, #plsql, #sql
11 comments
471 views