clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36288 in the last week).

select * from V$VERSION;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production 0
 hidden batch(es)


create table dept (id, dname) as select rownum, trim(column_value) from xmlTable ('"ACCOUNTING","OPERATIONS","RESEARCH","SALES"')
4 rows affected
 hidden batch(es)


select listagg(dname, ',') within group (order by dname) result from dept
RESULT
ACCOUNTING,OPERATIONS,RESEARCH,SALES
 hidden batch(es)