Oracle Database Discussions

Hi ,

I have the following requirements to generate a randomly password :

1- Each password should be 6 characters in length
2- Each password should include at least one uppercase letter, one lower case letter, one number and one special character (!, $, %, ?, &)
3- Passwords should not include the following letters/numbers:
* lower case l (L)
* upper case I (i)
* zero (0)
* upper case O (o)


Can you help me from where can I start, I know that there is a function DBMS_RANDOM.STRING but the function is not offering me all the possibilities (see above).


Thanks for anky help.