mysql oracle
1 ifnull | nvl
2 like concat(’%’, #{userName}, ‘%’) | like ‘%’ || #{studentName} || ‘%’
3 date_format | to_date
4 FIND_IN_SET (#{deptId},ancestors) | instr(’,’||ancestors||’,’,’,’||#{deptId}||’,’)<>0
5 sysdate() | sysdate
6 select database() | SELECT instance_name FROM v$instance