Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
select c.obj_name , obj_childs, obj_parents,d.Obj_type ,d.description,d.sub_system from (select obj_name, LISTAGG(obj_child, ',') WITHIN GROUP (ORDER BY obj_child) 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, LISTAGG(obj_parent, ',') WITHIN GROUP (ORDER BY obj_parent) 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 how can i immpelent this functions in my sql xmlagg or this select owner, type_name, coll_type, elem_type_name, upper_bound, length from all_coll_types where elem_type_name = 'VARCHAR2'; e.g. on my db, I can use sys.DBMSOUTPUT_LINESARRAY which is a varray of considerable size. or to_clob select department, cast(collect(name) as sys.DBMSOUTPUT_LINESARRAY) from emp group by department;
|Huge BLOB data type in Oracle how to retrieve in vb.net and crystal reports||6||45|
|pl/sql parameter is null sometimes||2||23|
|Syntax issue with my Where Clause SQL 2012||20||38|