from TSLimits a where 1=1 and a.TSLimits = ''
写成
from TSLimits a where 1=1 and nvl(a.TSLimits,'0')='0'
即可。可能是判断空的方式不支持吧。
from TSLimits a where 1=1 and a.TSLimits = ''
写成
from TSLimits a where 1=1 and nvl(a.TSLimits,'0')='0'
即可。可能是判断空的方式不支持吧。