oracle8.1.6 select contact_id, family_name, given_name, middle_name, company_name, g.category_name as category from contacts c, acs_objects o, contact_categories g where c.contact_id = o.object_id and c.category_type_id = g.category_type_id(+) and o.context_id = :package_id ${search_clause} ${starts_with_clause} order by $ordering