Oracle创建序列

--创建序列，初始值为1
CREATE SEQUENCE index_id MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 CYCLE NOCACHE

--删除序列
drop sequence index_id;

--循环，把序列跳到现有表的最后
 declare
 zhi integer;
 cursor mycur is select rownum rn, a.id from TABLE a;
 begin 
    for n in mycur loop 
        SELECT index_id.nextval  into zhi from dual;
        exit when mycur%notfound;
        end loop;
        commit;
   end;

例外在插入语句中一般需要加：

<selectKey keyProperty="id" resultType="int" order="BEFORE">
　　　　SELECT index_id.nextval as id FROM DUAL
</selectKey>
<insert>
INSERT INTO PRODUCT_ATTRIBUTES( name, age, sex )VALUES(#{name}, #{age}, #{sex})
</insert>