脚本:
 
CREATE OR REPLACE TRIGGER tri_news_eidit_confirm
AFTER UPDATE ON news_edit
for   each   row  
BEGIN
   /*如果审核权值=审核级数,新闻信息从新闻编辑移交给新闻表*/
     if :new.ne_newsconfirmlever>0 and :new.ne_newslevernumber>=:new.ne_newsconfirmlever
      and :new.ne_newsispublished=1 then
      
      insert into news(n_newseditid,n_newsfloderid,n_newstitle
                       ,n_newscontent,n_newsfrom,n_newshaspicture,
                        n_newshasmedia,n_newsfilename,n_newsfilepath
                        ,n_newshasfile,n_newsgood,n_newsispublished)
      select ne_id,ne_newsfloderid,ne_newstitle
             ,ne_newscontent,ne_newsfrom,ne_newshaspicture,ne_newshasmedia
             ,ne_newsfilename,ne_newsfilepath,ne_newshasfile
             ,ne_newsgood,ne_newsispublished
      from news_edit where ne_id=:new.ne_id;
      
     end if;end;