存储过程 create or replace procedure test(V_NAME varchar2, V_SAL number) is begin INSERT INTO USER_EMP T (EMPNO,ENAME,SAL) VALUES (SEQ_USER_NO.NEXTVAL,V_NAME,V_SAL); COMMIT; end ; 序列 -- Create sequence create sequence SEQ_USER_NO minvalue 1 maxvalue 9999999 start with 1 increment by 1 cache 10;