MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!