티스토리 뷰

공부

[Oracle] Update & Delete by Join Table

seunggabi 승가비 2020. 1. 18. 18:41
UPDATE A
SET value = (
	SELECT value
	FROM B
	WHERE B.id = A.id
);


DELETE FROM A
WHERE EXISTS (
	SELECT 1
	FROM B
	WHERE A.id = B.id
);

 

[출처] https://tora-it-kingdom.tistory.com/10

'공부' 카테고리의 다른 글

[Algorithm] Swap by 3 XOR  (0) 2020.01.18
[Oracle] Alter Table  (0) 2020.01.18
[Oracle] Update & Delete by Join Table  (0) 2020.01.18
[Spring] @Async & @AOP  (0) 2020.01.18
[HDFS] Export & Import  (0) 2020.01.18
[Python] Filter dict  (0) 2020.01.18
댓글
댓글쓰기 폼
공지사항
최근에 달린 댓글
Total
28,468
Today
5
Yesterday
49
«   2020/02   »
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
글 보관함