oracle8.1.6 select da.archive_name, da.archive_type_id, da.summary, da.description, da.description_type, u.last_name || ', ' || u.first_names as creation_user_name, da.creation_user, to_char(da.creation_date,'Mon DD, YYYY') as creation_date from download_archives_obj da, cc_users u where da.archive_id = :archive_id and u.user_id = da.creation_user