如何oracle查询条件里做if判断

来源:互联网 发布:ubuntu开机自启动mongo 编辑:程序博客网 时间:2024/06/10 08:24
select xxx,case when T.ELUDEMONEYTYPEITEM=901 then cast('901' as varchar2(20))else   cast((SELECTCOUNT (*)FROMJC_EVADETOLL_RECORD rdWHERErd.JCFUNID = T .REQUESTID) as varchar2(20)) end CANCEL_EVADETOLLCOUNT from tab