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.bz
		from DS_CFINFO_DETAILS b
		where b.CFBH=#{keyvalue} and b.mzjzlsh=#{jzlsh}
		<if test="yljg!=null and yljg!=''">
			AND YLJGDM=#{yljg}
		</if>