oracle8.1.6 select name, description, nvl(acs_object.name(default_assignee), 'N/A') as assignee_name from ttracker_categories where category_id = :category_id