Mercurial > dive4elements > river

view etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 9641:f96be528ee35

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Removed AS for table aliases in infrastructure queries to avoid Oracle problem
author mschaefer
date Mon, 02 Dec 2019 09:24:38 +0100
parents 5aa05a7a34b7
children
line wrap: on
line source
select.abflusstafel = \
    SELECT ABFLUSSTAFEL_NR, \
           ABFLUSSTAFEL_BEZ, \
           GUELTIG_VON, \
           GUELTIG_BIS, \
           PEGELNULLPUNKT, \
           AT.BFG_ID \
    FROM ABFLUSSTAFEL AT \
    WHERE MESSSTELLE_NR LIKE :number
http://dive4elements.wald.intevation.org