oracle select update

edu_test 테이블 구조

문제 : seq가 3 이상인 데이타를 조회 하여 reguserid와 chguserid를 'bearpro' 로 바꾸어라

update edu_test x
   set (x.seq, x.title, x.reguserid, x.chguserid)
     = (select a.seq
             , a.title
             , a.reguserid
             , a.chguserid
          from (
                select a.seq
                     , a.title
                     , 'bearpro' as reguserid
                     , 'bearpro' as chguserid
                  from edu_test a
                 where a.seq > 3
               ) a
         where a.seq = x.seq
       )
where seq > 3

결과 :