oracle存儲(chǔ)過程循環(huán)插入數(shù)據(jù) oracle用存儲(chǔ)過程插入一條數(shù)據(jù)（用序列實(shí)現(xiàn)）？
oracle用存儲(chǔ)過程插入一條數(shù)據(jù)（用序列實(shí)現(xiàn)）？首先創(chuàng)建一個(gè)序列create sequence seq1increment by 1start with 1maxvalue 999999999測(cè)試表
oracle用存儲(chǔ)過程插入一條數(shù)據(jù)（用序列實(shí)現(xiàn)）？
首先創(chuàng)建一個(gè)序列create sequence seq1increment by 1start with 1maxvalue 999999999測(cè)試表create table a(a number(20)，b varchar2(10))其次創(chuàng)建存儲(chǔ)create or replace procedure pro_insert(a_p in varchar2)isbegin insert into a (a，b) values (seq1.nextval，a_p) ---seq1.nextval是表示已經(jīng)有的序列上加1 commitend pro_insert插入數(shù)據(jù)SQL> set serveroutput onSQL> execut pro_insert("a") PL/SQL procedure successfully completed SQL> select * from a A B--------------------- ---------- 2 a