第1个回答 推荐于2017-11-25
首先创建一个序列
create sequence seq1
increment by 1
start with 1
maxvalue 999999999;
测试表
create table a
(
a number(20),
b varchar2(10)
);
其次创建存储
create or replace procedure pro_insert
(a_p in varchar2)
is
begin
insert into a
(a,b)
values
(seq1.nextval,a_p); ---seq1.nextval是表示已经有的序列上加1
commit;
end pro_insert;
插入数据
SQL> set serveroutput on;
SQL> execut pro_insert('a');
PL/SQL procedure successfully completed
SQL> select * from a;
A B
--------------------- ----------
2 a本回答被网友采纳