Mercurial > dive4elements > river
annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 5593:cf4cc385e7c6
Do not call recommend twice.
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Mon, 08 Apr 2013 15:23:01 +0200 |
parents | 7a68967ca72a |
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 |