oracle常用sql

字段替换
update PLAT_MENU_NEW set file_name=replace(file_name,'10.249.20.14','10.245.0.89:8080')  where file_name like '%unicom_lte%'

分页sql

<![CDATA[

SELECT * FROM
(
    SELECT A.*, ROWNUM RN
    FROM (sql语句) A
    WHERE ROWNUM <= #{end}
)
WHERE RN >= #{begin}

]]>