RANDOM.VALUE/STRING 랜덤 구하기 - 문자 랜덤

[10] RANDOM.VALUE/STRING 랜덤 구하기

--VALUE
SELECT CEIL(DBMS_RANDOM.VALUE(1000, 10000)) rand
FROM DUAL
CONNECT BY LEVEL <= 10;

--STRING
WITH TT AS(
SELECT DBMS_RANDOM.STRING('U', 10) rand FROM DUAL -- 대문자 VSBSMPRSWU
UNION ALL
SELECT DBMS_RANDOM.STRING('L', 10) rand FROM DUAL -- 소문자 myhhapzbgg
UNION ALL
SELECT DBMS_RANDOM.STRING('A', 10) rand FROM DUAL -- 영문자 SdObPAOuSw
UNION ALL
SELECT DBMS_RANDOM.STRING('X', 10) rand FROM DUAL -- 영숫자 ZYRA0IV2WH
UNION ALL
SELECT DBMS_RANDOM.STRING('P', 10) rand FROM DUAL -- 문자혼합 Yf^I,p"JR;
)
SELECT * FROM TT;