본문 바로가기

프로그래밍/Oracle SQL

[Oracle] 오라클 데이터가 없을경우에만 Insert하기

INSERT INTO RC_AGGREGATION_DEPT (
AGGREGATION_UUID,
DEPT_UUID,
USE_YN,
INSERT_UUID,
INSERT_DATE)
SELECT 
'aa' 
,'bb' 
, 'Y'
, 'cc'
, SYSDATE
FROM DUAL A
     WHERE NOT EXISTS (
SELECT 0 FROM RC_AGGREGATION_DEPT WHERE AGGREGATION_UUID = '18A091BF-9C4F-41B8-B192-551155934DB8' AND DEPT_UUID = '1F9AF4B4-8A69-4385-AD3D-35CF90632FB1A'
)

[참고] https://coding-factory.tistory.com/293