Saturday 19 September 2015

Update multiple column from select (update table from table)

update user_sdo_styles ori
set (ori.definition,ori.description,ori.geometry,ori.image,ori.type )=
(select my.definition,my.description,my.geometry,my.image,my.type
  from my_user_sdo_styles my where my.NAME = ori.NAME
)

No comments:

Post a Comment