MY QUERY IS like that
CREATE OR REPLACE function org_id
return varchar2
as
l_return varchar2(1000);
begin
select listagg(org_id,',')
within group ( order by org_id) into l_return
from hrms_org_struct where ORG_DEPT_NAME NOT
IN ('Marketing','IT-Support','HRM','Administration',
'Accounts and Finance','PS Sales','Training Sales',
'Tool Sales');
return l_return ;
end ;
declare
l_return varchar2(1000);
begin
l_return := org_id();
dbms_output.put_line(l_return);
end;
which return numbers like this
ORG_ID
561,553,552,551,550,549,548,547,546,545,544,543,542,541
which function should i use to return like this
'561','553','552','551','550','549','548','547','546','545','544','543','542','541'