CREATE TRIGGER aa ON dept FOR INSERT AS declare @id varchar(10) set @id = (select dept_id from inserted) if @id = '11' then drop table TABLE1 提示if附近有语法错误。 ---------------------------------- 在线等,解决后立即结帖。
BEGIN
if updating then
:new.updatetime := to_char(sysdate,'yyyymmddhh24miss');
else
:new.inserttime := to_char(sysdate,'yyyymmddhh24miss');
:new.updatetime := to_char(sysdate,'yyyymmddhh24miss');
end if;
END;