oracle触发器

来源：互联网发布：网络连接器编辑：程序博客网时间：2024/06/05 02:16

create table tb_rent
(
id number(20),
region varchar2(50),
room number(5),
hall number(5),
rent number(20),
memo varchar2(500)
);
create sequence seq_rent_id
start with 1
increment by 1;
create or replace trigger tr_rent_insert
before insert on tb_rent
for each row
begin
select seq_rent_id.nextVal into :NEW.id from dual;
end;

insert into tb_rent(region,room,hall,rent,memo) values('洪山区',2,1,800,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('青山区',2,1,800,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('山区',3,1,1200,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('红山区',4,1,1800,'环境好');
insert into tb_rent(region,room,hall,rent,memo) values('洪山区',2,1,770,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('洪山区',2,1,900,'交通方便');
insert into tb_rent(region,room,hall,rent,memo) values('洪区',3,1,1000,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('江夏区',1,1,320,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('洪山区',0,1,800,'马路边');
insert into tb_rent(region,room,hall,rent,memo) values('洪山区',2,1,600,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('关山区',2,0,800,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('洪山区',2,1,780,'小小地儿');
insert into tb_rent(region,room,hall,rent,memo) values('武昌区',2,1,1800,'家电齐全');
insert into tb_rent(region,room,hall,rent,memo) values('洪山区',2,1,560,'家电齐全');