oracle8.1.6 select site_node.url(node_id) as url, object_id, acs_object.name(object_id) as object_name, level from site_nodes start with node_id = :node_id connect by prior parent_id = node_id order by level asc