Mybatis写Oracle分页的方法

Oracle没有mysql像limit的语法，所以分页写法相当蛋疼

select T1.*,RN FROM(
    select  rownum rn,T.* FROM(
        select * from mall_shop ms
    ) T where rownum <![CDATA[<=]]> (#{page}*#{size})
) T1 where RN <![CDATA[>=]]> (#{page}-1)*10