oracle简单触发器 实例

 create table sp
(
t_id varchar2(40),
t_name varchar2(40),
constraint t_pk primary key(t_id)
)

create table t_sp
(
s_id varchar2(40),
s_name varchar2(40),
t_id varchar2(40) unique,
constraint s_pk primary key(s_id),
constraint s_fk foreign key(t_id) references sp(t_id)
)

insert into sp values('1','sp' )
insert into sp values('2','t_sp' )
insert into sp values('3','s_p' )


insert into t_sp values('1','sp','1' )
insert into t_sp values('2','t_sp','2' )
insert into t_sp values('3','s_p','3' )

--触发器

create or replace trigger tg_delete_organ
  AFTER delete on t_sp
  FOR EACH ROW
begin
delete from sp sp where sp.t_id=:old.t_id;
end;
--游标(无聊手动写的 简单的没什么逻辑)

 

declare
  cursor c_cursor(flg in int, t_sp in int) is
    select sp.name
      from (select rownum r, b.name from t_run_address_book b) sp
     where sp.r between flg and t_sp;
  v_name t_run_address_book.name%type;
begin
  open c_cursor(2, 5) ;fetch c_cursor
    into v_name;
  while c_cursor%found loop dbms_output.put_line('v_name的值：'||v_name);
  fetch c_cursor
    into v_name;
end loop;
close c_cursor;
end;