×

Loading...

如果你坚持要用Trigger,可以这样写:

laotang (laotang)
CREATE OR REPLACE TRIGGER UBLOB
BEFORE UPDATE ON USER_PROFILES
--注意是BEFORE,不是AFTER
FOR EACH ROW
BEGIN
:new.CREATE_DATE := SYSDATE;
END
(#275923@0)
2001-11-26 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: 各位ORACLE高手帮忙,小弟要写一个简单的TRIGGER。谢谢!

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论