![](https://yozm.wishket.com/media/news/2260/closeup-programer-hands-typing-machine-learning-code-laptop-keyboard-front-com_YAEcMD8.jpg)
Less than 1 minute
SHOW GRANT FOR :사용자;
MERGE INTO :테이블명 USING DUAL ON CONFLICT (:index컬럼명1, :index컬럼명2 /* ...[이하생략] */)
WHEN MATCHED THEN UPDATE SET
:컬럼명1 = :컬럼1의값
, :컬럼명2 = :컬럼2의값
/* ...[이하생략] */
WHEN NOT MATCHED THEN INSERT (
:컬럼명1, :컬럼명2 /* ...[이하생략] */
) VALUES (
:컬럼1의값, :컬럼2의값 /* ...[이하생략] */
);