Конструкция update в Oracle

DROP TABLE t1;
 
CREATE TABLE t1 AS
SELECT #cc66cc;">1 id, #ff0000;">'Москва XXXX'  name, #ff0000;">'МСК X' short_name FROM dual
UNION
SELECT #cc66cc;">2 id, #ff0000;">'Саратов XXXX' name, #ff0000;">'САР X' short_name FROM dual
UNION
SELECT #cc66cc;">3 id, #ff0000;">'Орел XXXX'    name, #ff0000;">'ОР X'  short_name FROM dual;
 
UPDATE t1
   SET name = #ff0000;">'Самара'
 WHERE id   = #cc66cc;">1;
 
commit;

drop table t1;
drop table t2;
 
-- создаем таблички
create table t1 #b1b100;">AS
SELECT #cc66cc;">1 id, 'Москва XXXX'  name, 'МСК X' short_name from dual
union
SELECT #cc66cc;">2 id, 'Саратов XXXX' name, 'САР X' short_name from dual
union
SELECT #cc66cc;">3 id, 'Орел XXXX'    name, 'ОР X'  short_name from dual;
 
create table t2 #b1b100;">AS
SELECT #cc66cc;">1 id, 'Москва City' name, 'МСК C' short_name from dual
union
SELECT #cc66cc;">2 id, 'Саратов City' name, 'САР C' short_name from dual
union
SELECT #cc66cc;">3 id, 'Орел City' name,    'ОР C' short_name from dual;
 
-- добавляем первичные ключи
ALTER TABLE t1 ADD CONSTRAINT t1_PK PRIMARY KEY (id);
ALTER TABLE t2 ADD CONSTRAINT t2_PK PRIMARY KEY (id);
 
-- Обновляем
UPDATE
(
SELECT t1.name       name,
       t1.short_name short_name,
       t2.name       name_new,
       t2.short_name short_name_new
  FROM t1,
       t2
 WHERE t1.id = t2.id     
) tt
SET tt.name = tt.name_new, tt.short_name = tt.short_name_new;
 
commit;
 
SELECT * FROM t1;
 

declare 
v_name_up VARCHAR2 (#cc66cc;">100);
begin
 
UPDATE
(
SELECT t1.name       name,
       t1.short_name short_name,
       t2.name       name_new,
       t2.short_name short_name_new
  FROM t1,
       t2
 WHERE t1.id = t2.id     
   AND t1.id = #cc66cc;">1
) tt
SET tt.name = tt.name_new, tt.short_name = tt.short_name_new
returning tt.name into v_name_up;
commit;
 
DBMS_OUTPUT.PUT_LINE(v_name_up);
end;