oracle8.1.6 begin site_node.delete(:node_id); end; select site_node.url(site_nodes.node_id) as url, site_nodes.node_id, site_nodes.parent_id, site_nodes.name, site_nodes.directory_p, site_nodes.pattern_p, site_nodes.object_id, (select acs_objects.object_type from acs_objects where acs_objects.object_id = site_nodes.object_id) as object_type, apm_packages.package_key, apm_packages.package_id, apm_packages.instance_name, apm_package_types.package_type from site_nodes, apm_packages, apm_package_types where site_nodes.object_id = apm_packages.package_id(+) and apm_package_types.package_key (+) = apm_packages.package_key select site_node.url(site_nodes.node_id) as url, site_nodes.node_id, site_nodes.parent_id, site_nodes.name, site_nodes.directory_p, site_nodes.pattern_p, site_nodes.object_id, (select acs_objects.object_type from acs_objects where acs_objects.object_id = site_nodes.object_id) as object_type, apm_packages.package_key, apm_packages.package_id, apm_packages.instance_name, apm_package_types.package_type from site_nodes, apm_packages, apm_package_types where site_nodes.node_id = :node_id and site_nodes.object_id = apm_packages.package_id(+) and apm_package_types.package_key = apm_packages.package_key select site_node.url(node_id) from site_nodes where object_id = :object_id order by site_node.url(node_id) desc