发表于 2009-1-5 19:48
| 
寰楀埌瀹㈡埛绔痠p 涓绘満鍚嶇殑瀛樺偍杩囩▼
鍙戝竷: 2008-6-30 22:35 | 浣滆: admin | 鏌ョ湅: 33娆
寰楀埌瀹㈡埛绔痠p 涓绘満鍚嶇殑瀛樺偍杩囩▼
銆愬瓧浣擄細灏 澶с
寰楀埌瀹㈡埛绔痠p 涓绘満鍚嶇殑瀛樺偍杩囩▼
浣滆咃細- 鏂囩珷鏉ユ簮锛- 鐐瑰嚮鏁帮細478 鏇存柊鏃堕棿锛2007-8-9 
琛╰est1 鏈塼1,t2,t3鍒楋紝绫诲瀷涓嶉檺锛屽綋琛ㄧ殑t3鍒楀彂鐢熷彉鍖栫殑鏃跺欎績鍙戣Е鍙戝櫒锛屽緱鍒扮敤鎴峰湴鍧锛屾満鍣ㄥ悕锛屽啓鍏ヨ〃test2
test2锛屾湁Y1,Y2,Y3涓変釜varchar2绫诲瀷鐨勫垪銆
CREATE OR REPLACE TRIGGER "SFDB"."TT3" BEFORE
INSERT
OR UPDATE OF "T3" ON "TEST1"
begin
insert into test2(y1,y2,y3) values('1',sys_context('userenv','ip_address'),sys_context('userenv','HOST'));
end;
