Mercurial > dive4elements > river

annotate etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 8680:19c38a47a276

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(issue1763) We have UNIQUE(station, bedHeight) since Rev 2d16f4a0bdcc and comparing with the other parameters will never return any row if any of them is null.
author Tom Gottfried <tom@intevation.de>
date Fri, 10 Apr 2015 17:42:10 +0200
parents 5aa05a7a34b7
children
rev   line source
4775
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
1 select.abflusstafel = \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
2 SELECT ABFLUSSTAFEL_NR, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
3 ABFLUSSTAFEL_BEZ, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
4 GUELTIG_VON, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
5 GUELTIG_BIS, \
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
6 PEGELNULLPUNKT, \
5480
7a68967ca72a AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4775
diff changeset
7 AT.BFG_ID \
7a68967ca72a AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4775
diff changeset
8 FROM ABFLUSSTAFEL AT \
4775
d9f1202cef78 Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4106
diff changeset
9 WHERE MESSSTELLE_NR LIKE :number
http://dive4elements.wald.intevation.org