create table t as select * from user_objects;

create table t1 as select * from t;

update t
  set
  created = ( select created from t1 where object_id = t.object_id ),
  object_name = ( select object_name from t1 where object_id = t.object_id ),
   object_type = ( select object_type from t1 where object_id = t.object_id )


MY ORIGINAL CODE
UPDATE DOBS.CP_ITEMIZED 
SET DOBS.CP_ITEMIZED.PHYSICIAN_FIRST_NAME = 
( 
SELECT P.First_Name_1 
FROM DOBS.CP_FED_HCP_FOR_RPT H 
INNER JOIN DOBS.CP_NPI_TAKEDAID_MATCH M ON H.TAKEDA_ID = M.TAKEDA_ID 
INNER JOIN DOBS.CP_CMS_PHYSICIAN_LIST P ON H.DCH_NPI = P.NPI 
WHERE DOBS.CP_ITEMIZED.TAKEDA_ID = H.TAKEDA_ID 
AND H.In_CMS_list = 'Yes' 
AND H.Valid_For_Federal = 'Yes' 
AND H.In_NPI_Match = 'Yes' 
), 
DOBS.CP_ITEMIZED.PHYSICIAN_MIDDLE_NAME = 
( 
SELECT P.Middle_Name_1 
FROM DOBS.CP_FED_HCP_FOR_RPT H 
INNER JOIN DOBS.CP_NPI_TAKEDAID_MATCH M ON H.TAKEDA_ID = M.TAKEDA_ID 
INNER JOIN DOBS.CP_CMS_PHYSICIAN_LIST P ON H.DCH_NPI = P.NPI 
WHERE DOBS.CP_ITEMIZED.TAKEDA_ID = H.TAKEDA_ID 
AND H.In_CMS_list = 'Yes' 
AND H.Valid_For_Federal = 'Yes' 
AND H.In_NPI_Match = 'Yes' 
) 
WHERE EXISTS 
( 
SELECT 1 
FROM DOBS.CP_FED_HCP_FOR_RPT 
WHERE DOBS.CP_FED_HCP_FOR_RPT.TAKEDA_ID = DOBS.CP_ITEMIZED.TAKEDA_ID 
);