테스트를 목적으로
대량 데이터를 생성할 방법이 있을까요?
Cartesian Product 등을 이용하여
1만건 혹은 10만건등 특정데이터를 insert 하는 방법이요...
insert into A
select * from dual ~~~
설명이 좀 난해했네요... ;;
SELECT LEVEL v , CEIL(LEVEL / 10) v , MOD(LEVEL, 10) v , CHR(64 + LEVEL) v , CHR(96 + LEVEL) v , dbms_random.random v , dbms_random.normal v , dbms_random.value v , ROUND(dbms_random.value(0, 1000000)) v , dbms_random.string('u', 6) v , dbms_random.string('l', 6) v , dbms_random.string('a', 6) v , dbms_random.string('x', 6) v , dbms_random.string('p', 6) v FROM dual CONNECT BY LEVEL <= 30 ;
/* dbms_random.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 */
답변 감사합니다~
완전 도움됐습니다~~ ^^