SQL programs

Data

Name debug hierarchy display

Description

SQL Program select distinct h1.object_id, h1.object_name, h2.object_id, h2.object_name, hh0.value from objects h1, objects h2, eav_objects hh1, eav_objects hh0 where h1.object_class=39 and h2.object_class=39 and hh1.attribute_id(+)=141 and hh0.attribute_id(+)=141 and h1.object_id=hh1.value(+) and hh0.object_id=h1.object_id

Maximum Rows

Maximum Columns