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