Posts

Showing posts from June, 2014

C# LINQ Grouping Data

var tureGoreHayvanBilgileri = from p in hayvanBilgileri group p by p.TURU into g selectnew { TURU = g.Key, HAYVANLAR = g };

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;