oracle8.1.6 select acs_object_types.pretty_name, acs_object_types.pretty_plural, acs_objects.creation_date, acs_object.name(acs_objects.object_id) object_name from acs_objects, acs_object_types where acs_objects.creation_user = :user_id and acs_objects.object_type in ('acs_message') and acs_objects.object_type = acs_object_types.object_type order by object_name, creation_date