oracle8.1.6 begin site_node.del(:node_id); end; select n.node_id, n.parent_id, n.name, n.directory_p, n.pattern_p, n.object_id, p.package_key, p.package_id, p.instance_name, t.package_type, (select count(*) from site_nodes where parent_id = n.node_id) as num_children from apm_packages p, apm_package_types t, (select node_id, parent_id, name, directory_p, pattern_p, object_id, rownum as nodes_rownum from site_nodes connect by parent_id = prior node_id start with node_id = :node_id) n where n.object_id = p.package_id(+) and t.package_key (+) = p.package_key order by n.nodes_rownum select n.node_id, n.parent_id, n.name, n.directory_p, n.pattern_p, n.object_id, p.package_key, p.package_id, p.instance_name, t.package_type, (select count(*) from site_nodes where parent_id = n.node_id) as num_children from apm_packages p, apm_package_types t, site_nodes n where n.object_id = p.package_id(+) and t.package_key (+) = p.package_key and (n.node_id = :node_id or n.parent_id = :node_id) order by n.nodes_rownum select n.node_id, n.parent_id, n.name, n.directory_p, n.pattern_p, n.object_id, p.package_key, p.package_id, p.instance_name, t.package_type, (select count(*) from site_nodes where parent_id = n.node_id) as num_children from apm_packages p, apm_package_types t, site_nodes n where n.node_id = :node_id and n.object_id = p.package_id(+) and t.package_key (+) = p.package_key select site_node.url(node_id) from site_nodes where object_id = :object_id order by site_node.url(node_id) desc