insert into dotlrn_departments (department_key, external_url) values (:department_key, :external_url) select 1 from dotlrn_departments where department_key = :department_key select pretty_name, department_key from dotlrn_departments_full order by pretty_name