Mercurial > dive4elements > river
annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4108:4c2b99d6af6c
Oracle: Added 'FROM DUAL' when selecting new ids from sequences.
flys-aft/trunk@3656 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 11 Jan 2012 17:53:32 +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 |