You can use LISTAGG in Oracle 11g:
with accounts as (
select 'acct1' acct_no from dual
union all select 'acct2' acct_no from dual
union all select 'acct3' acct_no from dual)
select listagg(acct_no, ', ') within group (order by acct_no)
acct1, acct2, acct3
Hi InoL ,
Sorry forgot to mention that i'm using Report builder 6i.
With Oracle 11g I mean the database version. You can use LISTAGG in a function in the database and call this function from your report.
If you don't have an Oracle 11g database, use STRAGG, which is not a standard Oracle function. You can Google for it.
function accFormula return Char is
declare cursor c1 is
select rownum,acct_no from accounts where customer_id=:cust_id;
for i in c1 loop
if c1%notfound then
I think its helpful to you.