oracle 创建自增列

--create table
create table demo
(
    demoID number(9) not null primary key,
    demoName nvarchar2(32),
    demoAddress nvarchar2(32)
);
--create sequence
create sequence demo_seq
increment by 1 
start with 1
nomaxvalue
nominvalue
nocache;

--create trigger
create or  replace trigger tr_demo
before insert on demo
for each row
begin
select demo_seq.nextval into :new.demoID from dual;
end;

--test
insert into demo(demoname,demoaddress)values('a','aa');
insert into demo(demoname,demoaddress)values('b','bb');
insert into demo(demoname,demoaddress)values('c','cc');

--select table
select * from demo;