SELECT PATH.sub, PATH.object_id, p.VALUE
FROM
(SELECT o.object_id, o.name, o.object_type_id, o.parent_id, SYS_CONNECT_BY_PATH (o.name, '/ ') sub
FROM objects o
WHERE object_type_id = 8
START WITH object_type_id = 5
AND o.object_id = 1083
CONNECT BY PRIOR o.object_id = o.parent_id) PATH
join params p
ON (PATH.object_id = p.object_id AND p.attr_id IN(18,19,20))
WHERE ((p.VALUE IS NULL) OR NOT regexp_like (p.VALUE, '(^[0-9]{1,}$)')) OR p.VALUE = 0