create procedure p_insert(p_num in number,p_flag out varchar2) as begin for i in 1..p_num loop insert into table_name (卡号,密码) values(id.nextval,dbms_random.random); end loop; commit; p_flag:='成功'; exception when others then rollback; p_flag:='失败'; end; /
给个建立序列和触发器的例子: 1.建立序列: CREATE SEQUENCE your_seq NOCYCLE MAXVALUE 9999999999 START WITH 2;2.建立触发器: CREATE OR REPLACE TRIGGER your_seq_tri BEFORE INSERT ON your_table1 FOR EACH ROW DECLARE next_id NUMBER; BEGIN SELECT your_seq.NEXTVAL INTO next_id FROM dual; :new.checkup_no := next_id; END;3.再建一个存贮过程,调用your_seq_tri,再使用随机数产生器,自已也动动手吧。
as
begin
for i in 1..p_num loop
insert into table_name (卡号,密码) values(id.nextval,dbms_random.random);
end loop;
commit;
p_flag:='成功';
exception
when others then
rollback;
p_flag:='失败';
end;
/
1.建立序列:
CREATE SEQUENCE your_seq
NOCYCLE
MAXVALUE 9999999999
START WITH 2;2.建立触发器:
CREATE OR REPLACE TRIGGER your_seq_tri
BEFORE INSERT ON your_table1
FOR EACH ROW
DECLARE
next_id NUMBER;
BEGIN
SELECT your_seq.NEXTVAL
INTO next_id
FROM dual;
:new.checkup_no := next_id;
END;3.再建一个存贮过程,调用your_seq_tri,再使用随机数产生器,自已也动动手吧。