오라클의 DBMS_RANDOM.STRING() 함수를 CUBRID 식으로 구현하는 방법

select
dbms_random.string('l', 10)
from dual;

kjrdzqsrcw

select
dbms_random.string('u', 10)
from dual

HRJOWGIZHH

select
dbms_random.string('a', 10)
from dual

DcXFZOieAe

select
dbms_random.string('x', 10)
from dual

LKGRBM3XDV

SELECT
GROUP_CONCAT(CHR((RANDOM() % 26) + 97) SEPARATOR '')
FROM db_root
CONNECT BY LEVEL <= 10

jrprzvyzhl

SELECT
GROUP_CONCAT(CHR((RANDOM() % 26) + 65) SEPARATOR '')
FROM db_root
CONNECT BY LEVEL <= 10

CTNEOBSDFZ

SELECT
 GROUP_CONCAT((DECODE(RANDOM() % 2, 0, CHR((RANDOM() % 26) + 97),
         CHR((RANDOM() % 26) + 65))) separator '')
FROM
 db_root
CONNECT BY
 LEVEL <= 10

hCsiqCbqaT

SELECT
 GROUP_CONCAT((DECODE(RANDOM() % 2, 0, CHR((RANDOM() % 26) + 65),
         CHR((RANDOM() % 10) + 48))) separator '')
FROM
 db_root
CONNECT BY
 LEVEL <= 10

0O75SFUXK2