Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
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 obj_name, obj_child, obj_parent, child_id, obj_id, parent_id from ( select c.obj_name, oc.obj_name obj_child, op.obj_name obj_parent, ec.obj_child child_id, c.cal_objid obj_id, c.obj_type, c.obj_title, c.description, ep.obj_parent parent_id from object_list c, cal_erd ec, object_list oc, cal_erd ep , object_list op where ec.obj_parent(+) = c.cal_objid -- if object is no parent still get an empty row and ec.obj_child = oc.cal_objid(+) -- if no child relation found stil get an empty row to get empty child-data and ep.obj_child(+) = c.cal_objid -- if object is not a child still get an empty row and ep.obj_parent = op.cal_objid(+) -- if no parent relation found stil get an empty row to get empty parent-data )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Oracle DB Slows After Datapump Until Next Reboot||27||172|
|update statement in oracle||9||53|
|Read XML values||8||69|
|Oracle cluster with iSCSI storage - multiple targets or single target with multiple LUNs?||4||93|
Join the community of 500,000 technology professionals and ask your questions.