Oracle Database Discussions

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.string in 10g

599834Sep 25 2007 — edited Sep 25 2007

hi

can you please help me in getting a random string that consists of minimun of one special character, capital and small letter when i try to use dbms_random.string for apltha numeric charector i getting only
combination of small and capital letters

select dbms_random.string ('A', 20) from dual;

DBMS_RANDOM.STRING('A',20)
------------------------------------------------------------------------------------------------------------------------
AEnFUEgUCQGBfihCdzNu

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2007

Added on Sep 25 2007

#general-database-discussions

3 comments

741 views