annotate etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 8610:1f6b30310360

(issue1754) Allow ranges where start > end also for beddifferences.
author Andre Heinecke <andre.heinecke@intevation.de>
date Tue, 24 Mar 2015 11:08:39 +0100
parents 5aa05a7a34b7
children
rev   line source
5258
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
1 next.gauge.id = \
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
2 SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
3 next.timeinterval.id = \
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
4 SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
5 next.discharge.id = \
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
6 SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
7 next.discharge.table.values.id = \
da1e897c7224 Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4108
diff changeset
8 SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL

http://dive4elements.wald.intevation.org