Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

Oracle Function Listagg
WITH q_tab AS 
(SELECT level idx, DECODE(MOD(level,2),0,'EVEN','ODD') num_type
 FROM DUAL CONNECT BY level <=10)
SELECT 
 num_type,
 CAST(LISTAGG(idx,', ') WITHIN GROUP (ORDER BY idx) 
  AS VARCHAR2(30)) num_type_list
FROM q_tab
GROUP BY num_type
ORDER BY num_type DESC;

Oracle 11g LISTAGG output


Oracle COUNT(*) OVER() to get similar output

Oracle 12c Release 2 (12.2) - LISTAGG

Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: August 09, 2015

  39910