Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
but am geting the error above am in form 11gR2 AND MY DATABASE is 11gR2 my query run well in my sql developer
select c.obj_name , obj_childs, obj_parents,d.Obj_type ,d.description,d.sub_system from (select obj_name,RTRIM(EXTRACT(XMLAGG(XMLELEMENT("x",obj_child || ',') order by obj_child), '/x/text()').getclobval(), ',') obj_childs from (select distinct c.obj_name, oc.obj_name obj_child from cal_obj c, cal_erd_link ec, cal_obj oc where ec.obj_parent(+) = c.obj_name and ec.obj_child = oc.obj_name(+) ) group by obj_name ) c , (select obj_name, RTRIM(EXTRACT(XMLAGG(XMLELEMENT("x",obj_parent || ',') order by obj_parent), '/x/text()').getclobval(), ',') obj_parents from (select distinct c.obj_name, op.obj_name obj_parent from cal_obj c, cal_erd_link ep , cal_obj op where ep.obj_child(+) = c.obj_name and ep.obj_parent = op.obj_name(+) ) group by obj_name ) p , cal_obj d where c.obj_name = p.obj_name and d.obj_name = c.obj_name
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.