按这个方式来加nvl nvl((select nvl(rele_office_id,'0') from tab_test3 where account_id=a.account_id),'0') rele_office_id,
如: select nvl((select '' from dual), 'asd') from dual
12:18:34 SQL> select nvl('a','is null') from dual where 1=2;未选定行已用时间: 00: 00: 00.7812:19:40 SQL> select nvl((select 'a' from dual where 1=2),'is null') from dual;NVL((SE ------- is null已用时间: 00: 00: 00.62 12:19:56 SQL>
nvl((select rele_office_id from tab_test3 where account_id=a.account_id),0)
找到解决办法了,谢谢! (select nvl(rele_office_id,'0') from tab_test3 where account_id=a.account_id) rele_office_id, 改为 nvl((select rele_office_id from tab_test3 where account_id=a.account_id),'0') rele_office_id, 即可!
nvl((select nvl(rele_office_id,'0') from tab_test3 where account_id=a.account_id),'0') rele_office_id,
select nvl((select '' from dual), 'asd') from dual
-------
is null已用时间: 00: 00: 00.62
12:19:56 SQL>
(select nvl(rele_office_id,'0') from tab_test3 where account_id=a.account_id) rele_office_id,
改为
nvl((select rele_office_id from tab_test3 where account_id=a.account_id),'0') rele_office_id,
即可!