This is an old revision of the document!

Project Takedown : PL/SQL migration keynotes

Documentation
Name:	Project Takedown : PL/SQL migration keynotes
Description:	Project Takedown : PL/SQL migration keynotes
Modification date :	28/10/2020
Owner:	jholgado
Tags:	OracleDB, MySQL, PostgreSQL, Ceph…

Ora2My

Oracle	Mysql	key notes
`VARCHAR2`	`VARCHAR`	`varchar2` does no exists on mysql
`FUNCTION FUNCTIONNAME(PARM1 IN NUMBER) RETURN NUMBER AS \| FUNCTION FUNCTIONNAME(PARM1 NUMBER) RETURN NUMBER AS`	`IN` in the variable declaration is not needed
`LISTAGG(column, ' ') WITHIN GROUP (`	`GROUPCONCAT() \| LISTAGG does not exists and GROUPCONCAT` sintax is completely different, this is hardcore
`PLSINTEGER \| NUMBER \| just that… \| \| PARALLELENABLE`	none	does not exists in mysql
`TOCHAR() \| CHAR() \| just that… \| \| SYSDATE \| SYSDATE() \| just that… \| \| RAISEAPPLICATIONERROR \| signal \| See this \| \| TOCHAR(SYSDATE, 'FORMAT')`	`TIMEFORMAT() or DATEFORMAT()`	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