创建:
CREATE SEQUENCE "OMTEST"."SEQ_EMP_CAPITAL" MINVALUE 1 MAXVALUE 999999999999999999 INCREMENT BY 1 START WITH 121 CACHE 20 NOORDER NOCYCLE ;
使用:
<insert id="insert">
<selectKey keyProperty="id" resultType="int" order="BEFORE">
select SEQ_EMP_CAPITAL.NEXTVAL from dual
</selectKey>
INSERT INTO emp_intellectual_capital(