你測一下,我沒有環境:
BEGIN
FOR v_Counter IN 1..6666 LOOP
INSERT INTO temp_table(kh,pass,zq)
VALUES ('AA'||lpad(to_char(v_Counter),4,'0'),
round(dbms_random.values(100000,999999)),
to_date('2003-06-06','yyyy/mm/dd'));
END LOOP;
END;
/
BEGIN
FOR v_Counter IN 1..6666 LOOP
INSERT INTO temp_table(kh,pass,zq)
VALUES ('AA'||lpad(to_char(v_Counter),4,'0'),
round(dbms_random.values(100000,999999)),
to_date('2003-06-06','yyyy/mm/dd'));
END LOOP;
END;
/
确认dbms_rand包已经创建