oracle8.1.6 select package_id, site_node.url(node_id) as url from apm_packages p, site_nodes n where p.package_id = n.object_id