JiYoung Dev 🖥

[database 고급] merge (2023.08.08) 본문

full stack/database

[database 고급] merge (2023.08.08)

Shinjio 2023. 8. 8. 15:49

 

 

-- MERGE
MERGE INTO TB_CUST_TEL
USING DUAL
   ON ( CUST_ID = 'C0007' AND TEL_DVCD = '휴대폰')
WHEN MATCHED THEN
UPDATE 
   SET TEL_NO = '010-7777-7777'
WHEN NOT MATCHED THEN
INSERT (CUST_ID, TEL_DVCD, TEL_NO)
VALUES ('C0007', '휴대폰', '010-7777-7777');

SELECT * FROM TB_CUST_TEL;

 

 

 

'full stack > database' 카테고리의 다른 글

[database 고급] 집합연산자 (2023.08.08)  (0) 2023.08.08
[database 고급] CTAS (2023.08.08)  (0) 2023.08.08
[database 고급] case문 (2023.08.08)  (0) 2023.08.08
[database 고급] EXISTS (2023.08.07)  (0) 2023.08.07
[Oracle Database] ROWNUM, TOP-N, 페이징 기술, 서브쿼리 (2023.03.28~29)  (0) 2023.03.28
'full stack/database' Related Articles more