每次登陆数据库自动修改FLG
create
or
replace
trigger
CMT001_LOGIN_FLG
before update on cmt001_user
for each row
declare
begin
IF :NEW.LOGIN_FLG = ' 1 ' THEN
:NEW.LOGIN_FLG : = ' 0 ' ;
END IF ;
end CMT001_LOGIN_FLG;
before update on cmt001_user
for each row
declare
begin
IF :NEW.LOGIN_FLG = ' 1 ' THEN
:NEW.LOGIN_FLG : = ' 0 ' ;
END IF ;
end CMT001_LOGIN_FLG;