oracle开发系列（一）让人抓狂的错误之null值与无值(无结果)(二)
ount(1)
into count_var
from tssa_dsg.eosorg_t_organization b,
(select a.*
from tssa_dsg.bndict_t_dictionary a
where a.BUSINTYPEID = 'WH_CH_ORAPROPERTY'
and a.status = '0') a
where b.orgproperty = a.businid(+)
and b.orgid = orgid_var;--统计操作日志表的机构id是否在机构静态表里
if (count_var >
0) then--在里面 上面这个条件作用跟if(orgid_var is null)是一样的 是忽略 操作日志表的机构id不在机构静态表里的情况。