How Oracle sets up auto-increment

1) Create a sequence:

1234567

createsequenceSEQ_TEST --字段名minvalue 1        --最小值maxvalue XXXXX      --设置最大值start with 1      --从1开始计数increment by1    --每次加1个nocycle           --一直累加，不循环nocache;          --不建缓冲区

2) sequence configuration in MyBatis:

Insert before MyBatis The new method you want to invoke

　

123	<selectKey resultType="java.lang.Long"order="BEFORE"keyProperty="id">     SELECT SEQ_TEST.Nextval as id from DUAL  </selectKey>

Note: The keyproperty here is the primary key attribute in Pojo, and it is important to note that there is no way to get the primary key ID already saved.

3) Also, attach the query sequence and delete the SQL

Inquire

1	select* fromuser_sequences;

Delete

1	DROPSEQUENCESEQ_TEST;

How Oracle sets up auto-increment