MySQL轉換Oracle的注意事項,mysqloracle

來源:互聯網
上載者:User

MySQL轉換Oracle的注意事項,mysqloracle
limit--->oracle分頁,
dateformat--->oracle日期格式化,
now()---->擷取系統時間,
在MySQL裡不是關鍵字到oracle裡就是關鍵字了


mysql oracle
order by id desc   limit #{offset},#{pageSize} where rownum <= #{offset}+#{pageSize} )
where rn >#{offset}) 
order by id DESC
#{startDate}
t.createtime
to_date('#{startDate}','yyyy-mm-dd HH24:MI:SS')
to_char(t.createtime,'yyyy-MM-dd') as createtime
now() sysdate
type在MySQL中不是關鍵字 type 在oracle裡是關鍵字 需要在SQL語句中將關鍵字全部大寫並且加上雙引號


相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.