jppg/SQLite vs Oracle.md

## SQLite vs Oracle.md

      
    Raw
  

              SQLite vs Oracle.md
            
          
Oracle
SQLite
Example


NVL
IFNULL
SELECT nome, ifnull(premios, 0) FROM emp;


(+)
LEFT OUTER JOIN
SELECT e.nome, e.ndep, d.nome FROM dep d left outer join emp e on e.ndep = d.ndep ORDER BY e.ndep;


ASCII
Not supported


RPAD
Not supported


CHR
Not supported


CONCAT
Not supported


SYSDATE
date('now')
SELECT date('now');


DECODE
CASE...WHEN...THEN...ELSE...END
select funcao, CASE funcao WHEN 'Presidente' THEN 'Chefão' WHEN 'Continuo' THEN 'Escravo' ELSE  'INDEFINIDO' END as DECODE from emp;
Oracle	SQLite	Example
NVL	IFNULL	SELECT nome, ifnull(premios, 0) FROM emp;
(+)	LEFT OUTER JOIN	SELECT e.nome, e.ndep, d.nome FROM dep d left outer join emp e on e.ndep = d.ndep ORDER BY e.ndep;
ASCII	Not supported
RPAD	Not supported
CHR	Not supported
CONCAT	Not supported
SYSDATE	date('now')	SELECT date('now');
DECODE	CASE...WHEN...THEN...ELSE...END	select funcao, CASE funcao WHEN 'Presidente' THEN 'Chefão' WHEN 'Continuo' THEN 'Escravo' ELSE 'INDEFINIDO' END as DECODE from emp;