DBMS_RANDOM.STRAIN('s' gives non-alpha-numeric characters.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 16 Feb 2001 19:17:27 GMT
Message-ID: <3a8d7c1e.67164500@news.alt.net>

From the package:

 FUNCTION string (opt char, len NUMBER)

          /* "opt" specifies that the returned string may contain:


             'u','U'  :  upper case alpha characters only

             'l','L'  :  lower case alpha characters only

             'a','A'  :  alpha characters only (mixed case)

             'x','X'  :  any alpha-numeric characters (upper)

             'p','P'  :  any printable characters

          */
        RETURN VARCHAR2;  -- string of <len> characters (max 60)

So I tried:

SELECT DBMS_RANDOM.STRING('x', 20) FROM Dual;

and received:

DBMS_RANDOM.STRING('X',20)

---

7N62RKLPM=@O>S_at_CB8>R I thought 'x' was only supposed to return alphanumerics characters?

Brian Received on Fri Feb 16 2001 - 13:17:27 CST