http://devblog.billism.com/?p=12MySQL 에서 사용하는 INSERT … ON DUPLICATE KEY UPDATE 문장이나 REPLACE 문장을 오라클에서 사용하려면?
정답은 MERGE ...
[MySQL]
INSERT INTO TABLE (a,b,c)
VALUES (1,2,3)
ON DUPLICATE KEY UPDATE b=2, c=3;
REPLACE INTO table_a (a,b,c)
VALUES(1,2,3);
[Oracle]
MERGE INTO SCHEMA.table_a TA
USING (
SELECT '1' a, '2' b, '3' c
FROM DUAL
) E
ON (TA.a = E.a)
WHEN MATCHED THEN
UPDATE SET TA.b = E.b, TA.c = E.c
WHEN NOT MATCHED THEN
INSERT (TA.a, TA.b, TA.c)
VALUES (E.a, E.b, E.c);
정답은 MERGE ...
[MySQL]
INSERT INTO TABLE (a,b,c)
VALUES (1,2,3)
ON DUPLICATE KEY UPDATE b=2, c=3;
REPLACE INTO table_a (a,b,c)
VALUES(1,2,3);
[Oracle]
MERGE INTO SCHEMA.table_a TA
USING (
SELECT '1' a, '2' b, '3' c
FROM DUAL
) E
ON (TA.a = E.a)
WHEN MATCHED THEN
UPDATE SET TA.b = E.b, TA.c = E.c
WHEN NOT MATCHED THEN
INSERT (TA.a, TA.b, TA.c)
VALUES (E.a, E.b, E.c);
댓글 0
- 전체
- Android+iPhone+etc.
- Apache+Tomcat
- ASP
- ASP.NET
- DataBase
- HTML / CSS
- JavaScript
- JSP
- Linux Server
- PHP
- Raspberry pi
- Windows Server
- WIPI
- Etc.