Mercurial > dive4elements > river
annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4109:8ba11e13ae8a
AFT-Import: Insert
new discharge tables as 'Historische Abflusstafel' kind.
flys-aft/trunk@3956 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 08 Feb 2012 09:43:12 +0000 |
| 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 |