[ORACLE] UPDATE, MERGE

oracle 일 경우 update , merge 둘 다 가능

---

update 

UPDATE TB_TRIP_SCHEDULE_ADMIN 
SET (S_DATE, E_DATE, MODIFY_USER_ID, MODIFY_DATE, RET_SCHEDULE_NO) 
= ( SELECT S_DATE, E_DATE, SIN_USER_ID, MAKE_DATE, TRIP_SCHEDULE_NO FROM TB_TRIP_SCHEDULE WHERE STATUS = 3 AND TRIP_SCHEDULE_NO = 85 )
WHERE TRIP_SCHEDULE_ADMIN_NO = (SELECT RET_SCHEDULE_ADMIN_NO FROM TB_TRIP_SCHEDULE WHERE STATUS = 3 AND TRIP_SCHEDULE_NO = 85);

 

 

merge 

하나의 쿼리문으로 INSERT, UPDATE, DELETE 작업을 해야 하는 경우에 사용.

 

 

 

 

 

 

[참고]

https://studyhard24.tistory.com/216

https://gent.tistory.com/406

http://www.gurubee.net/article/55897

http://www.gurubee.net/article/45668

https://kaos119.tistory.com/entry/SQL-update-%EB%AC%B8%EC%97%90%EC%84%9C-with-%EC%A0%88-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0