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;