Oracle 表id实现自增

首先建一个表student

create table student(    id int,    stu_name varchar2(10))

建立一个sequence

create sequence test_on_studentincrement by 1maxvalue 9999minvalue 1000start with 1000

测试一下

插入一条数据

insert into student values(test_on_student.nextval,'张三')

</pre><pre name="code" class="sql">

</pre><pre name="code" class="sql">