方法一:序列spa
第一步建立序列:CREATE SEQUENCE topic_sequence
INCREMENT BY 1
START WITH 1
NOMAXVALUE
nocycle
nocacheselect
第二步插入数据:insert into pd_topic (id,topic_name)
values( topic_sequence .nextval,'zhangsan') //红色部分为序列得到的id值方法
方法二:触发器next
第一步先建立序列:CREATE SEQUENCE topic_sequence
INCREMENT BY 1
START WITH 1
NOMAXVALUE
nocycle
nocache数据
第二步建立触发器: create or replace trigger topic_trigger
before insert on pd_topic
for each row
begin
select topic_sequence.nextval into :new.ID from dual;
end;top
第三步插入数据,不用在添加id字段,触发器会自动自增:co
insert into pd_topic (topic_name)
values( 'zhangsan')new