元テーブルに存在するが、複製テーブルには存在しない
を追加する
INSERT INTO DEPT_BK(DEPTNO,DNAME,LOC,ADDRESS,AGE)
SELECT DEPTNO,DNAME,LOC,ADDRESS,AGE FROM DEPT
MINUS
SELECT DEPTNO,DNAME,LOC,ADDRESS,AGE FROM DEPT_BK
INSERT INTO repTN(col1,col2)
SELECT col1,col2 FROM xbbTN
MINUS
SELECT col1,col2 FROM repTN;
INSERT INTO tab1(col1,col2)
SELECT
a.col1
,a.col2
FROM
tab2 a
WHERE
NOT EXISTS (SELECT
'x'
FROM
tab1 b
WHERE
a.col1 = b.col1);
INSERT INTO DEPT_BK(DEPTNO,DNAME,LOC,KOUSHINBI,ADDRESS,AGE)
SELECT
DEPTNO
,DNAME, LOC,KOUSHINBI,ADDRESS,AGE
FROM
DEPT X
WHERE
DEPTNO != X.DEPTNO
INSERT INTO tab1(col1,col2)
SELECT
col1
,col2
FROM
tab2
WHERE
col3 != '001'
and col4 is not null;
