Listing 2: OPT PARAMETER in DBMS_RANDOM strinG
Here are the OPT parameter values, their meanings, and generated sample outputs when the DBMS_RANDOM STRING function passes that parameter value.
Value Meaning Sample output
U Uppercase letters DBMS_RANDOM.STRING('U',20)
LBLRTNOZBGDDEXRDAPGE
FHYUPCQKIKZNKJJBWNZN
L Lowercase letters DBMS_RANDOM.STRING('L',20)
cupmmjtgcsxiblgzaibt
zwqzsmivudqqroaajygg
A Mixed-case alpha- DBMS_RANDOM.STRING('A',20)
numeric characters FOsgh_VtqIi`dcWPWUQt
AidjSWQFi[JYraUWBmeb
X Uppercase alpha- DBMS_RANDOM.STRING('X',20)
numeric characters O1L0F67FI=20?9;@I:NC
3E@PL51IC4R:?3SGRP?2
P Any "printable" character DBMS_RANDOM.STRING('P',20)
jE+3hPw_v6|+K-T^3nd.
>/v/K&_E/gQOa{ep*BVb
|
Oracle Magazine Issue Archive
Printer View