Mercurial > dive4elements > river
annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4642:ca18d8d06218
Multiplicate diameter with 1000 to have mm instead of m.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Wed, 05 Dec 2012 10:05:14 +0100 |
| parents | 9ba12119e662 |
| children | d9f1202cef78 |
| rev | line source |
|---|---|
|
4106
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
1 select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
2 ABFLUSSTAFEL_BEZ, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
3 GUELTIG_VON, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
4 GUELTIG_BIS, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
5 PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
6 |