oracle8.1.6 select acs_object.name(:object_id) from dual select party_id, acs_object.name(party_id) as name from parties