利用记录类型变量更新记录

declare
  v_dept departments%Rowtype;
begin
  v_dept.departmentid   := 30;
  v_dept.locationid     := 1100;
  v_dept.departmentname := 'computer';
  update departments set row = v_dept where departmentid = 300;
end;