select xxx,case when T.ELUDEMONEYTYPEITEM=901 then cast('901' as varchar2(20))
else cast((SELECT
COUNT (*)
FROM
JC_EVADETOLL_RECORD rd
WHERE
rd.JCFUNID = T .REQUESTID) as varchar2(20)) end CANCEL_EVADETOLLCOUNT from tab
如何oracle查询条件里做if判断
最新推荐文章于 2024-07-28 01:05:05 发布