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!

Generate special characters randomly

RNNov 4 2009 — edited Nov 4 2009

I want to generate random password which should include atleast one special character which could be any special character except @. dbms_random.string('p',1) will give 1 printable character which could be any uppercase or lowercase letter or any numeric value too. But how can I just generate 1 special character (excluding @)?

Thanks,

Edited by: user5406804 on Nov 4, 2009 5:50 AM

This post has been answered by Frank Kulash on Nov 4 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2009

Added on Nov 4 2009

#plsql, #sql

11 comments

5,084 views