This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.
×
Loading...
Close
Home
Share
如果你坚持要用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)
Last Updated: 2001-11-26
This post has been archived. It cannot be replied.
Share
Report
Replies, comments and Discussions:
各位ORACLE高手帮忙,小弟要写一个简单的TRIGGER。谢谢!
枫下论坛主坛
/
工作学习
/
IT技术讨论