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