clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335853 fiddles created (27447 in the last week).

create table table1(col1 varchar2(20));
 hidden batch(es)


insert into table1 values('file1');
1 rows affected
 hidden batch(es)


insert into table1 values('file2');
1 rows affected
 hidden batch(es)


insert into table1 values('file3');
1 rows affected
 hidden batch(es)


select * from table1;
COL1
file1
file2
file3
 hidden batch(es)


select rtrim (xmlagg (xmlelement (c, col1 || ',')).extract ('//text()'), ',') col1 from table1;
COL1
file1,file2,file3
 hidden batch(es)


SELECT SUBSTR (SYS_CONNECT_BY_PATH (col1, ','), 2) col1 FROM (SELECT col1 , ROW_NUMBER () OVER (ORDER BY col1 ) rn, COUNT (*) OVER () cnt FROM table1) WHERE rn = cnt START WITH rn = 1 CONNECT BY rn = PRIOR rn + 1;
COL1
file1,file2,file3
 hidden batch(es)