Skip to content

Instantly share code, notes, and snippets.

@jppg

jppg/SQLite vs Oracle.csv

Created January 29, 2020 17:56
Show Gist options
  • Save jppg/70df5cc4130dc0043105ea4c28ab01c0 to your computer and use it in GitHub Desktop.
Save jppg/70df5cc4130dc0043105ea4c28ab01c0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQLite vs Oracle.csv
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 3.
| Oracle | SQLite | Example |
| NVL | IFNULL | SELECT nome, ifnull(premios, 0) FROM emp; |
| (+) | LEFT OUTER JOIN | SELECT e.nome "Nome", e.ndep "NDep", d.nome "Dep" FROM dep d left outer join emp e on e.ndep = d.ndep ORDER BY e.ndep; |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment