17,377
社区成员
发帖
与我相关
我的任务
分享
declare
cursor c_ur is select rownum from t;
v_rownum number(18,0);
v_num1 t.num1%type;
begin
for r_ur in c_ur loop
select trunc(dbms_random.value(1,101)) into v_num1 from dual; -- 将要更新的数值
v_rownum := r_ur.rownum;
update t set num1 = v_num1 where rownum = v_rownum;
end loop;
commit;
end;
/
create table t(
num1 number(18,0)
);
declare
v_insert_num number(18,0); -- 你想插入记录的条数
v_rand_num number(18,0);
begin
v_insert_num := 100; -- 比如:插入100条记录行
for i in 1 .. v_insert_num loop
select trunc(dbms_random.value(1,101)) into v_rand_num from dual;
insert into t (num1) values(v_rand_num);
end loop;
commit; -- 提交一下
end;
/
declare
v_insert_num number(18,0); -- 你想插入记录的条数
begin
v_insert_num = 100; -- 比如:插入100条记录行
for i in 1 .. v_insert_num
insert into t(num1) select trunc(dbms_random.value(1,101)) from dual;
end loop;
end;
/
declare
v_insert_num number(18,0); -- begin
v_insert_num := 100; -- //更新一百条
for i in 1 .. v_insert_num loop
update plugs_mat set num1= select trunc(dbms_random.value(1,101)) from dual
where stauts = 200;
end loop;
commit
end;