Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;

BANNER

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE	11.2.0.2.0	Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

-- LISTAGG arrived in Oracle 11.2
-- (one statement per batch here: Oracle rejects a batch holding two)
create table pet (owner varchar2(10), name varchar2(10))
insert into pet
select 'ann','rex' from dual union all
select 'ann','bo'  from dual union all
select 'bob','sam' from dual

3 rows affected

select owner, listagg(name, ', ') within group (order by name) as pets
from pet group by owner order by owner

OWNER
PETS

ann
bo, rex

bob
sam

-- recursive WITH also arrived in 11.2
with r (n) as (
  select 1 from dual
  union all
  select n + 1 from r where n < 5
)
select n from r

N

1

2

3

4

5