desc linkman; --通讯录
Name Type Nullable Default Comments
-------- ------------- -------- ------- --------
ID VARCHAR2(100) 自动增长的序列seq_ID
GROUP_ID VARCHAR2(100) Y NULL
USERID VARCHAR2(100) Y '-1'
NAME VARCHAR2(100) Y '-1' 名字
EMAIL VARCHAR2(100) Y NULL email
PHONE VARCHAR2(100) Y NULL
REMARK VARCHAR2(500) Y NULL
desc whitelist; --白名单
Name Type Nullable Default Comments
----------- ------------- -------- ------- --------
ID VARCHAR2(50) 自动增长的序列seq_ID
USER_CARDID VARCHAR2(100)
USEREMAIL VARCHAR2(100) Y
EMAIL VARCHAR2(50) Y email
NAME VARCHAR2(20) Y 名字 当我向whitelist中添加一条记录insert into whitelist(ID,USER_CARDID,USEREMAIL,EMAIL,NAME) values('1000','279F','[email protected]','[email protected]','aaa'); 就同时向linkman中也insert into linkman(ID,USERID,name,email) values('1000','[email protected]','[email protected]','aaa');
当我从whitelist中根据ID删除一条记录delete from whitelist where ID='1000'就同时也向linkman中也delete from linkman where ID = '1000';
whitelist和linkman通过whitelist.ID和linkman.ID关联 想通过写个触发器实现该功能 上面还一个帖子一样的30分
Name Type Nullable Default Comments
-------- ------------- -------- ------- --------
ID VARCHAR2(100) 自动增长的序列seq_ID
GROUP_ID VARCHAR2(100) Y NULL
USERID VARCHAR2(100) Y '-1'
NAME VARCHAR2(100) Y '-1' 名字
EMAIL VARCHAR2(100) Y NULL email
PHONE VARCHAR2(100) Y NULL
REMARK VARCHAR2(500) Y NULL
desc whitelist; --白名单
Name Type Nullable Default Comments
----------- ------------- -------- ------- --------
ID VARCHAR2(50) 自动增长的序列seq_ID
USER_CARDID VARCHAR2(100)
USEREMAIL VARCHAR2(100) Y
EMAIL VARCHAR2(50) Y email
NAME VARCHAR2(20) Y 名字 当我向whitelist中添加一条记录insert into whitelist(ID,USER_CARDID,USEREMAIL,EMAIL,NAME) values('1000','279F','[email protected]','[email protected]','aaa'); 就同时向linkman中也insert into linkman(ID,USERID,name,email) values('1000','[email protected]','[email protected]','aaa');
当我从whitelist中根据ID删除一条记录delete from whitelist where ID='1000'就同时也向linkman中也delete from linkman where ID = '1000';
whitelist和linkman通过whitelist.ID和linkman.ID关联 想通过写个触发器实现该功能 上面还一个帖子一样的30分
解决方案 »
- jobs 手动运行可以 自动运行就会报错、断开。怎么解决啊!
- struts2中如何把csv导入到oracle
- ora-00904: 'right' invalid identifier
- 关于左外连接的效率问题
- 怎么给view 增加列
- 各位大虾 求助 :ORA-21779: 持续时间不活动
- 有懂这个问题的人近来帮忙!!!!
- 在线等如何在oracle中只备份存储过程/函数/和包(100分)
- Oracle9i,导出整个数据库,原来很快,现在慢
- ORA-29540: 类 oracle/jpub/runtime/dbws/DbwsProxy 不存在
- 取两张表所不共有的数据
- 谁帮我看看这条sql是什么意思?
create or replace trigger tr_audit_linkman
after insert or delete on whitelist
for each row
begin
case
when inserting then
insert into linkman(ID,USERID,name,email) values(:new.id,:new.USER_CARDID,:new.USEREMAIL,:new.NAME);
when deleting then
delete from linkman where id=:old.id;
end case;
end;
after insert or update or delete on whitelist
for each row
begin
case
when inserting then
insert into linkman
values(:new.id,:new.user_cardid...);
when deleting then
delete from linkman where id=:old.id;
end case;
end;