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中添加一条记录就同时向linkman中也insert into linkman(ID,name,email) values(?,?,?);
当我从whitelist中根据ID删除一条记录就同时也向linkman中也delete from linkman where ID = ?;
whitelist和linkman通过ID关联想通过写个触发器实现该功能
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中添加一条记录就同时向linkman中也insert into linkman(ID,name,email) values(?,?,?);
当我从whitelist中根据ID删除一条记录就同时也向linkman中也delete from linkman where ID = ?;
whitelist和linkman通过ID关联想通过写个触发器实现该功能
alter delete/insert
on test
for each row
declare
begin
delete from test;
delete from test1;
commit;
exception
when others then
rollback;end
Before insert or delete On whitelist
for each row Begin If INSERTING then insert into linkman(ID,name,email) values(?,?,?); elsif deleting then
delete from linkman where ID = ?;
endif; End; /
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 名字
LinkManID VARCHAR2(100) 自动增长的序列seq_ID当我向whitelist中添加一条记录insert into whitelist(ID,USER_CARDID,USEREMAIL,EMAIL,NAME,LinkManID) values(seq_ID.nextval,'279F','[email protected]','[email protected]','aaa',seq_ID.nextval); 就同时向linkman中也insert into linkman(ID,USERID,name,email) values(seq_ID.nextval,'[email protected]','[email protected]','aaa');
当我从whitelist中根据ID删除一条记录delete from whitelist where LinkManID='1000'就同时也向linkman中也delete from linkman where ID = '1000';
whitelist和linkman通过whitelist.LinkManID和linkman.ID关联 想通过写个触发器实现该功能
上次真不好意思,没有描述清楚,刚学这,希望大家快点告诉我,不胜感激!
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关联 想通过写个触发器实现该功能