以下是只是笔记,供以后需要时查看,应该会持续更新,不定时的
达梦
--批量插入数据(循环)
CREATE OR REPLACE PROCEDURE BATCH_XX AS
DECLARE
random_num INTEGER;
state_str VARCHAR2;
BEGIN
FOR i IN 1..10 LOOP
--获取随机数,包含1和3
random_num := ROUND(dbms_random.value(1,3));
IF random_num = 1 THEN
state_str := '10';
ELSEIF random_num = 2 THEN
state_str := '10';
ELSE
state_str := '60';
END IF;
insert into xx values('');
END LOOP;
commit;
END;