Skip to content

Instantly share code, notes, and snippets.

@ivanelson

ivanelson/between.sql

Created May 18, 2015 13:41
Show Gist options
  • Save ivanelson/02fed59bb184f2853230 to your computer and use it in GitHub Desktop.
Save ivanelson/02fed59bb184f2853230 to your computer and use it in GitHub Desktop.
Download ZIP
Between - Diferença entre Postgres e Oracle
Raw
between.sql
ORACLE:
- cd_chave_la varchar2(6)
SELECT cd_chave_la from tab_inaugura where cd_chave_la between 'TEZ 1 ' and 'TEZ 1Z';
// OUTPUT:
"TEZ 1S"
POSTGRESQL
- cd_chave_la varchar(6)
SELECT cd_chave_la from tab_inaugura where cd_chave_la between 'TEZ 1 ' and 'TEZ 1Z';
// OUTPÙT:
"TEZ 1S"
"TEZ15"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment