This discussion is archived
2 Replies Latest reply: Apr 24, 2013 1:49 PM by P.Forstmann RSS

Oracle Express 11.2

user8167598 Newbie
Currently Being Moderated
Hi

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

Thanks

Russell
  • 1. Re: Oracle Express 11.2
    sb92075 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points