2 Replies Latest reply: Apr 24, 2013 3:49 PM by P.Forstmann RSS

    Oracle Express 11.2

    user8167598
      Hi

      Does the express version (11.2) support listagg / wm_concat / Group_concat ?

      Thanks

      Russell
        • 1. Re: Oracle Express 11.2
          sb92075
          user8167598 wrote:
          Hi

          Does the express version (11.2) support listagg / wm_concat / Group_concat ?

          Thanks

          Russell
          yes
          • 2. Re: Oracle Express 11.2
            P.Forstmann
            yes/no/no:

            SQL> select * from v$version;
            
            BANNER
            --------------------------------------------------------------------------------
            Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
            PL/SQL Release 11.2.0.2.0 - Production
            CORE    11.2.0.2.0      Production
            TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
            NLSRTL Version 11.2.0.2.0 - Production
            
            SQL> select region_id, listagg(country_name,' ') within group (order by country_name) as countries
              2  from countries
              3  group by region_id;
            
             REGION_ID COUNTRIES
            ---------- --------------------------------------------------------------------------------
                     1 Belgium Denmark France Germany Italy Netherlands Switzerland United Kingdom
                     2 Argentina Brazil Canada Mexico United States of America
                     3 Australia China India Japan Malaysia Singapore
                     4 Egypt Israel Kuwait Nigeria Zambia Zimbabwe
            
            SQL> select region_id, wm_concat(country_name,' ') as countries
              2  from countries
              3  group by region_id;
            select region_id, wm_concat(country_name,' ') as countries
                              *
            ERROR at line 1:
            ORA-00904: "WM_CONCAT": invalid identifier
            
            
            SQL> select region_id, group_concat(country_name,' ') as countries
              2  from countries
              3  group by region_id;
            select region_id, group_concat(country_name,' ') as countries
                              *
            ERROR at line 1:
            ORA-00904: "GROUP_CONCAT": invalid identifier
            
            
            SQL>