Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
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.
Join the community of 500,000 technology professionals and ask your questions.