oracle分页查询sql语句xml版

<select id = "listQueryDpcInfoDO"  resultMap ="getListDpcInfoDO" >

        select * from
        (
        SELECT A.*, ROWNUM RN
        # from后为具体查询表语句
        FROM ( select *
        from DPCINFO
        <where>
            <if test="centerInputParam.province !=null">
                province = #{centerInputParam.province }
            </if>

            <if test="centerInputParam.city !=null">
                and  city = #{centerInputParam.city}
            </if>
            <if test="centerInputParam.area !=null">
                and county = #{centerInputParam.area}
            </if>
            <if test="centerInputParam.begindate !=null and centerInputParam.enddate !=null">
                and to_char(time,'yyyy-mm-dd') between #{centerInputParam.begindate} and #{centerInputParam.enddate}
            <