Skip to main content


Showing posts from June, 2014

C# LINQ Grouping Data

var tureGoreHayvanBilgileri = from p in hayvanBilgileri                                group p by p.TURU into g                                select new { 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;