Oracle | Mysql | key notes |
VARCHAR2 | VARCHAR | varchar2 does no exists on mysql |
FUNCTION FUNCTION_NAME(PARM1 IN NUMBER) RETURN NUMBER AS | FUNCTION FUNCTION_NAME(PARM1 NUMBER) RETURN NUMBER AS | IN in the variable declaration is not needed |
LISTAGG(column, ' ') WITHIN GROUP ( | GROUP_CONCAT() | LISTAGG does not exists and GROUP_CONCAT sintax is completely different, this is hardcore |
PLS_INTEGER | NUMBER | just that… |
PARALLEL_ENABLE | none | does not exists in mysql |
TO_CHAR() | CHAR() | just that… |
SYSDATE | SYSDATE() | just that… |
RAISE_APPLICATION_ERROR | signal | See this |
TO_CHAR(SYSDATE, 'FORMAT') | TIME_FORMAT() or DATE_FORMAT() | See TIME_FORMAT and DATE_FORMAT |
CONSTANT | none | does not exists |
%TYPE & %ROWTYPE | %TYPE & %ROWTYPE | Yes, is the same, but maybe you might have a loot at 1, 2 |