create or replace trigger NEW_TIG
before insert on news
referencing old as old new as new
for each row beginselect to_char(sysdate,'yyyymmdd')||lpad(DEF_SEQ.nextval,8,'0') into :news.id from dual;
exception
when others then
-- consider logging the error and then re-raise
raise;
end NEW_TIG 大侠们,帮我看看,哪错了?
before insert on news
referencing old as old new as new
for each row beginselect to_char(sysdate,'yyyymmdd')||lpad(DEF_SEQ.nextval,8,'0') into :news.id from dual;
exception
when others then
-- consider logging the error and then re-raise
raise;
end NEW_TIG 大侠们,帮我看看,哪错了?
END
这些东西呢?