오라클 랜덤데이터 생성

CREATE TABLE TEST_MULTI_COL
AS
SELECT ROWNUM AS IDX,
dbms_random.string('U', 5) AS ENAME, 
CAST('8'||CEIL(DBMS_RANDOM.VALUE(1,9))||'0'||CEIL(DBMS_RANDOM.VALUE(1,9))||CEIL(DBMS_RANDOM.VALUE(10,30))||'-'||'1'||CEIL(DBMS_RANDOM.VALUE(111111,999999)) AS CHAR(14)) REGI_NUM,
DBMS_RANDOM.STRING('l',10)||'@'||DBMS_RANDOM.STRING('l',5)||'.com' AS EMAIL,
TO_CHAR(DBMS_RANDOM.STRING('A', 8)) AS REGI_CODE
FROM dual
CONNECT BY ROWNUM <= 100000;
COMMIT;

랜덤데이터를 생성 하는 구문 이다.