view flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4930:28f992c0f937 dami

SCHEMA CHANGES: Add tables for Hochwasserschutzanlagen This adds the first draft of Hochwasserschutzanlagen tables hws_points and hws_lines which replace the old hws table and also lookup tables fed_states and hws_kinds.
author Andre Heinecke <aheinecke@intevation.de>
date Mon, 28 Jan 2013 17:42:18 +0100
parents d9f1202cef78
children 7a68967ca72a
line wrap: on
line source
select.abflusstafel = \
    SELECT ABFLUSSTAFEL_NR, \
           ABFLUSSTAFEL_BEZ, \
           GUELTIG_VON, \
           GUELTIG_BIS, \
           PEGELNULLPUNKT, \
           BFG_ID \
    FROM ABFLUSSTAFEL \
    WHERE MESSSTELLE_NR LIKE :number

http://dive4elements.wald.intevation.org