oracle存储过程循环插入数据 oracle用存储过程插入一条数据（用序列实现）？

oracle用存储过程插入一条数据（用序列实现）？首先创建一个序列create sequence seq1increment by 1start with 1maxvalue 999999999测试表

oracle用存储过程插入一条数据（用序列实现）？

首先创建一个序列create sequence seq1increment by 1start with 1maxvalue 999999999测试表create table a(a number(20)，b varchar2(10))其次创建存储create or replace procedure pro_insert(a_p in varchar2)isbegin insert into a (a，b) values (seq1.nextval，a_p) ---seq1.nextval是表示已经有的序列上加1 commitend pro_insert插入数据SQL> set serveroutput onSQL> execut pro_insert("a") PL/SQL procedure successfully completed SQL> select * from a A B--------------------- ---------- 2 a