Is there a function like XMLAGG in PLJSON ?
If not then how can i get AGG a resultset which is giving multiple columns out into one column and get the redult in json format.
L_S:='WITH par as (
select null ind,
)select case when par.ind is null then
(select caa.acctid , ba.start_service_date from tlg.billing_account ba,mps.customer_accountassociation caa
where to_number(caa.acctid) = ba.ban and rownum<2)
end from dual,par';
This will give an error of too many values since more than one column is getting retrived from inner select query..
Any workaround for this..??
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.