oracle - How to show all value of a single column into a single row in pl/sql report? -

i trying show single column single row in pl/sql report. want

    item     -----     itme1     item2     item4     item5 

to

    item     -----     item1,item2,item3, item4, item5 

i have used following code

function cf_hs_descformula return char v_items varchar2(600); begin v_items:=:hs_desc; if v_items not null    v_items:=v_items||',';  end if; return v_items; end; 

but not working. please tell me how can that?

you can use listagg in oracle:

select listagg(name, ', ')      within group (order name) "name_list" table1;