oracle没有ORACLE自增字段这样的功能，但是通过触发器(trigger)和序列(sequence)可以实现。
假设关键字段为id，建一个序列，代码为：
create sequence seq_ids_increment
minvalue 1
maxvalue 99999999
start with 1
increment by 1
nocache
order;
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
建解发器代码为： ------------------------------
create or replace trigger tri_ids_increment
before insert on loginuser
for each row
declare
nextid number;
begin
IF :new.id IS NULL or :new.id=0 THEN
select seq_ids_increment.nextval
into nextid
from sys.dual;
:new.id:=nextid;
end if;
end tri_ids_increment;
方法2
//---------------------------------------------
create or replace trigger tri_ids_increment
before insert on loginuser
for each row
begin
select seq_ids_increment.nextval
into :new.id
from dual;
end tri_ids_increment;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/786540/viewspace-1003472/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量140
-
访问量1115933
