Tuesday, January 14, 2014

Access Query 2 Oracle IIF

IIF ... CASE

    f.bla AS S_Bla,
    (
      CASE TO_CHAR(Reparaturdatum, 'YYYY')
        WHEN '1899'
        THEN '-'
        ELSE TO_CHAR(Reparaturdatum, 'DD.MM.YYYY')
      END)                   AS S_RDatum,
    f.Fallzaehler            AS S_Fallzaehler,

NZ ... NVL

No comments: