PL/SQL CASE Statement

SELECT (
  CASE
    WHEN COUNT(*)                           >0
    AND wmsys.wm_concat(vew.kulak_kupe_no) IS NOT NULL
    THEN COUNT(*)
      ||' ADET: '
      || wmsys.wm_concat(vew.kulak_kupe_no)
    ELSE NULL
  END)
FROM vew_test_view vew
WHERE VEW.POST_MORTEM_ID =:P_POST_MORTEM_ID;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document