Oracle 需要这么写 AND IS_ABROAD=CASE WHEN '${IS_ABROAD}' <> 'null' THEN '${IS_ABROAD}' ELSE IS_ABROAD END
赞 0 2025-01-03 10:32
多值查询，但是参数为空，这种情况怎么处理，报错显示： CASE WHEN ('0NGCBA6DAR000010080','0NGMBA5DBH000008968') != '' THEN a.battery_sn in ('0NGCBA6DAR000010080','0NGMBA5DBH000008968') ELSE 1=1 END
赞 0 2024-08-08 15:29
2 评论
Oracle 需要这么写
AND IS_ABROAD=CASE WHEN '${IS_ABROAD}' <> 'null' THEN '${IS_ABROAD}' ELSE IS_ABROAD END
赞 0 2025-01-03 10:32
多值查询，但是参数为空，这种情况怎么处理，报错显示： CASE WHEN ('0NGCBA6DAR000010080','0NGMBA5DBH000008968') != '' THEN a.battery_sn in ('0NGCBA6DAR000010080','0NGMBA5DBH000008968') ELSE 1=1 END
赞 0 2024-08-08 15:29