Considerations for converting MySQL to Oracle: mysqloracle

Considerations for converting MySQL to Oracle: mysqloracle
Limit ---> oracle paging,
Dateformat ---> oracle date formatting,
Now () ----> get the system time,
In MySQL, It is a keyword instead of a keyword in oracle.

Mysql	Oracle
Order by id desc limit # {offset}, # {pageSize}	Where rownum & lt; =#{ offset} + # {pageSize }) Where rn & gt; # {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 is not a keyword in MySQL.	Type is a keyword in oracle. in SQL statements, uppercase keywords and double quotation marks must be added.