oracle 触发器 自动增长ID

oracle 触发器　自动增长ID

关键词： oracle    触发器　自动增长ID                                          

 

create table T_TEST
(
 ID   number(4)    not null, 
        UserName varchar2(50) not null,
        PASSWORD  varchar2(50) not null,  
        primary key (ID)
)

CREATE SEQUENCE Seq_T_TEST INCREMENT BY 1  START  WITH  1 MAXVALUE  9999  CYCLE  NOCACHE

create or replace trigger bef_ins_T_TEST
before insert on T_TEST
referencing old as old new as new for each row
begin
select Seq_T_TEST.nextval into :new.ID from dual;
end;
/

insert into T_TEST(UserName,PASSWORD) Values('jhf','jhf');
insert into T_TEST(UserName,PASSWORD) Values('tt','tt');