oracle update select

1.update   id   set   (a,b,c)=(select   a,b,c   from   ida   where   ida.id=id.id);

2.update   id   t1   set   a=(select   t2.a   from   ida   t2   where   t1.id=t2.id),b=(select   t2.b   from   ida   t2   where   t1.id=t2.id),c=(select   t2.c   from   ida   t2   where   t1.id=t2.id)

 

UPDATE tz_main SET (A,B,C)=(select A,B,C from tz_main where id=''xxxxxx)  WHERE id='xxxxxxx'

 

UPDATE RMP_BUSINESSINFO RBI SET (COORDINATE_NAME) = (SELECT CONTACT_ADDRESS FROM RMP_BUSINESSINFO RB WHERE RBI.BUSINESS_ID = RB.BUSINESS_ID)