我以下的code无论NOT MATCHED 或MATCHED, UTL_FILE.PUT_LINE(l_file_id,l_comp_line ) 都输出一行。怎样才能只在NOT MATCHED 时输出,而MATCHED时跳过UTL_FILE.PUT_LINE(l_file_id,l_comp_line )? 谢谢先!
MERGE INTO emas_rec_tracking a
USING ( select r_recrinfo.saradap_pidm
pidm,
stu_rec.studentno
stu_id,
r_recrinfo.saradap_term_code_entry term_code,
l_comp_line
text
from dual) b
ON ( a.pidm = b.pidm and a.stu_id = b.stu_id and a.term_code = b.term_code and a.text = b.text)
WHEN NOT MATCHED THEN
INSERT (a.pidm, a.stu_id, a.term_code, a.text, a.activity_date)
values (b.pidm, b.stu_id , b.term_code ,b.text, sysdate) ;
UTL_FILE.PUT_LINE(l_file_id,l_comp_line );
|