--写个过程判断一下,在选择插入或更新;
CREATEORREPLACEprocedureadd_or_update(str1VARCHAR2,str2VARCHAR2,kfgzdbhVARCHAR2,as_logOUTVARCHAR2)
IS
vv_str1VARCHAR2(20);
vv_str2VARCHAR2(20);
BEGIN
--得到值
SELECT(SELECTt.tqmcFROMdw_tqtWHEREt.tqbs=b.tqbs),(SELECTy.mcFROMdw_yxbyqyWHEREy.tqbs=b.tqbs)
INTOvv_str1,vv_str2
FROMfw_kfgdxxa,fw_tsywfjxxb
WHEREa.kfgzdbs=b.kfgzdbs
ANDa.kfgzdbh=kfgzdbh;--fw_kfgdxx:传入123456789000000
--判断
IFvv_str1ISNULLORtrim(vv_str1)=''THEN
INSERTINTO;--插入对应的值
ELSE
UPDATE;--更新对应的值
ENDIF;
endp_check_end; |