oracle 序列CREATE SEQUENCE HIBERNATE_SEQUENCE increment by 1 start with 10000 minvalue 1
Oracle我用的不是很多 嘿嘿
建个sequence——>将这个sequence作用于你需要的那张表
CREATE OR REPLACE TRIGGER "SET_TABLE_ID" BEFORE INSERT ON "表名" FOR EACH ROWDECLARE NEXT_ID NUMBER; BEGIN SELECT 序列名.NEXTVAL INTO NEXT_ID FROM DUAL; :NEW."字段" := NEXT_ID; END;
increment by 1
start with 10000
minvalue 1
CREATE OR REPLACE TRIGGER "SET_TABLE_ID" BEFORE
INSERT ON "表名"
FOR EACH ROWDECLARE
NEXT_ID NUMBER;
BEGIN
SELECT 序列名.NEXTVAL INTO NEXT_ID FROM DUAL;
:NEW."字段" := NEXT_ID;
END;
sequence 建立好后 在java程序增加记录时 调用sequence如果是纯sql 插入 还是转到oracle区问吧
(imagecode, housecode, houseimage, imagedesc, desc1, desc2)
values
(HOUSE_IMAGE_SEQ.NEXTVAL,201,'11111111111111', 1, 1, 1);
HOUSE_IMAGE_SEQ是tb_house_image表的序列
<id name="id" type="integer" column="id">
<generator class="sequence">
<param name="sequence">seq_tab_yunfeiid</param>
</generator>
</id>
序列号调用.nextval方法就可以执行插入勒