User Tools

Site Tools


dba:oracle:project_takedown:key_notes

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:dodger
Tags: OracleDB, MySQL, PostgreSQL, Ceph…

Ora2My

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
dba/oracle/project_takedown/key_notes.txt · Last modified: 2022/02/11 11:36 by 127.0.0.1