随便建的一个表test
create table test (a number(4));
现在我想在表中a列插入100行随机数据，数据值在50-100之间的随机数，请问各位大侠我该如何写？
------解决思路----------------------
INSERT INTO TEST
SELECT ROUND(dbms_random.value(50,100)) FROM dual
CONNECT BY ROWNUM<=100;
------解决思路----------------------
insert into test
select dbms_random.value(50, 100) from dual connect by rownum <= 100;