Oracle and MySQL

Oracle	MySQL
REGEXP_LIKE(URL,#{URL})	#{URL} regexp url
TO_DATE(#{param},'yyyy-MM-dd HH24:MI:SS')	str_to_date(#{param},'%y-%m-%d %H:%I:%S')
TO_CHAR(sysdate,'yyyy-MM-dd HH24:MI:SS')	data_format(sysdate,'%y-%m-%d %H:%I:%S')
SUBSTR(PATH,INSTR(PATH,'image') + LENGTH('image'))	SUBATRING(PATH,LOCATE('image',PATH) + LENGTH('image'))
<foreach separator=";" collection = "list" item="param" open="begin" close=";end;"> </foreach>	<foreach separator=";" collection="list" item="param"> </foreach>
WITH childernTree(.....)	WITH recursive childernTree
NVL(param,' ')	IFNULL(param,' ')
OFFSET #{page.offset} ROWS fetch NEXT #{page.pageSize} ROWS ONLY	LIMIT  #{page.offset}, #{page.pageSize}
CREATE SEQUENCE SEQ_XXX    MINVALUE 1    MAXVALUE 999999999 START VITH 1  INCREMENT BY 1 CACHE 20;