select pretty_name,
description,
external_url
from dotlrn_departments_full
where department_key = :department_key
update dotlrn_departments
set external_url = :external_url
where department_key = :department_key
update dotlrn_community_types
set pretty_name = :pretty_name,
description = :description
where community_type = :department_key