annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4496:d8992459b408

Add method to return the facets of an artifact This methos should be used to get the facets of an artifact instead of accessing the facets member variable directly.
author Björn Ricks <bjoern.ricks@intevation.de>
date Wed, 14 Nov 2012 11:11:04 +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

http://dive4elements.wald.intevation.org