17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER repository_index_i_trigger AFTER insert ON FAQ.T_REPOSITORY
FOR EACH ROW
BEGIN
insert into t_repository_index(pk_auto_id,uk_file_id,title,content,type,level_id,post_user_name,update_time,OPE_CODE,annex,key_word)
select pk_auto_id,uk_file_id,title,content,RETYPE,level_id,post_user_name,nvl(update_time,sysdate),OPE_CODE,annex,key_word from v_repository_index_lucene where pk_auto_id=new.PK_AUTO_ID;
END;
CREATE OR REPLACE TRIGGER repository_index_i_trigger AFTER insert ON FAQ.T_REPOSITORY
FOR EACH ROW
BEGIN
insert into t_repository_index(pk_auto_id,uk_file_id,title,content,type,level_id,post_user_name,update_time,OPE_CODE,annex,key_word)
select pk_auto_id,uk_file_id,title,content,RETYPE,level_id,post_user_name,nvl(update_time,sysdate),OPE_CODE,annex,key_word from v_repository_index_lucene where pk_auto_id=:new.PK_AUTO_ID;
END;