写个触发器,当删除表中一条信息时同时删除另外一个表中ID号一样的信息
解决方案 »
- oracle 升级时出现negative time问题
- 如何快速把一个机器的Oracle数据库快速移植到另一台机器上?
- Oracle9i的价格及用户数限制?
- 请问oracle中group by 能用在两张表的关联上吗?请高手指点
- 请教在sqlplus输入何命令可以让数据库做checkpoint?
- next_day(sysdate,n) 中的n是什么意思啊?
- 安装ORACLE9I中遇到的问题,创建不了数据库
- 还是存储过程的游标问题
- 请教=与in,any的差别!谢谢!
- 用insert语句插入数据序列自增为1,使用hibernate执行插入数据序列就变成2了
- Pear(DB_DataObject) 连接 oracle 的配置文件
- 表或视图不存在
after delete on table1
for each row
begin
delete table2
where ID = :old.ID;
end tr_delete;
after delete on table1
for each row
begin
delete table2
where ID = :old.ID;
end tr_delete;
after delete on table1
for each row
begin
delete table2
where ID = :old.ID;
end tr_delete;
2 id number(10) not null,
3 name varchar2(3)
4 );
Table created
SQL> create table t2(
2 id number(10) not null,
3 name varchar2(3)
4 );
Table created
SQL> insert into t1(id,name)
2 select 100,'aaa' from dual union all
3 select 101,'bbb' from dual union all
4 select 102,'ccc' from dual union all
5 select 103,'ddd' from dual union all
6 select 104,'eee' from dual
7 /
5 rows inserted
SQL>
SQL> insert into t2(id,name)
2 select 100,'aaa' from dual union all
3 select 101,'bbb' from dual union all
4 select 102,'ccc' from dual union all
5 select 103,'ddd' from dual union all
6 select 104,'eee' from dual
7 /
5 rows inserted
SQL> select * from t1;
ID NAME
----------- ----
100 aaa
101 bbb
102 ccc
103 ddd
104 eee
SQL> select * from t2;
ID NAME
----------- ----
100 aaa
101 bbb
102 ccc
103 ddd
104 eeeSQL> create or replace trigger trigger_delete
2 after delete on t1
3 for each row
4 begin
5 dbms_output.put_line(:old.id);
6 delete t2 where id=:old.id;
7 end trigger_delete;
8 /
Trigger createdSQL> delete t1 where id = 100;
1 row deletedSQL> select * from t1;
ID NAME
----------- ----
101 bbb
102 ccc
103 ddd
104 eee
SQL> select * from t2;
ID NAME
----------- ----
101 bbb
102 ccc
103 ddd
104 eee