Mercurial > dive4elements > river

annotate etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 8683:cfafe5764509

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(issue 1796) Scheme change! Add model for seddb_name lookup table.
author Andre Heinecke <andre.heinecke@intevation.de>
date Mon, 13 Apr 2015 11:24:32 +0200
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