oraacle 几个函数的用法

select ROW_NUMBER() over(order by b.yzzh,b.mzjzlsh,b.CFMXH) XH,    b.YNBMXS YPDM,    CASE WHEN (b.YZZH is NULL or b.YZZH='NULL') THEN b.XMMC               ELSE  b.XMMC||'  ['||b.YZZH||']' END YPMC,    REPLACE(b.YPGG,' ','') GG,    CASE substr((cast(round(b.MXXMDJ,2) as decimal(10,2))),0,1)             WHEN '.' THEN to_char(cast(round(b.MXXMDJ,2) as decimal(10,2)),'0.99')            ELSE to_char(cast(round(b.MXXMDJ,2) as decimal(10,2))) END DJ,     to_char(b.MXXMSL)||b.MXXMDW SL,    CASE substr((cast(round(b.MXXMJE,2) as decimal(10,2))),0,1)             WHEN '.' THEN to_char(cast(round(b.MXXMJE,2) as decimal(10,2)),'0.99')            ELSE to_char(cast(round(b.MXXMJE,2) as decimal(10,2))) END XJ,    b.YFYL ZLFF,b.YPPC SJAP,    case when (b.MCSL=0 or b.MCSL is null or b.MCSL is null) then '' else ( CASE substr(cast(round(b.MCSL,2) as decimal(10,2)),0,1)             WHEN '.' THEN to_char(cast(round(b.MCSL,2) as decimal(10,2)),'0.99') ||b.MCSLDW            ELSE to_char(cast(round(b.MCSL,2) as decimal(10,2))) ||b.MCSLDW END )end YFSL,    b.MCJLDW JLDW,b.MXXMDW BZDW,b.MCSLDW MCDW,b.CFTS,b.bzfrom DS_CFINFO_DETAILS bwhere b.CFBH=#{keyvalue} and b.mzjzlsh=#{jzlsh}<if test="yljg!=null and yljg!=''">AND YLJGDM=#{yljg}</if>