¡áÂü°í4.2.1 ´ÙÁß°ÇÀÇ INSERT
--À̷»ý¼º
INSERT INTO CNTTNFHIST(
/* º¯°æÀÌ·Â ¸ñ·Ï Á¶È¸ */
SELECT A.REGISTER_SNO,
A.REGISTER_GBN,
A.ATCL_PRD_SNO,
ROWNUM HIST_SEQ,
A.HIST_DATE,
A.HIST_ITEM_CODE,
A.HIST_BEFO,
A.HIST_AFFT,
A.HIST_MAN_NAME HIST_MAN_NAME,
A.HIST_MAN_DUTY HIST_MAN_DUTY,
A.MW_TAKE_NO,
'Y' USES_YN,
SYSDATE REGIST_TIME,
'88888888' REGIST_ID,
SYSDATE UPDATE_TIME,
'88888888' UPDATE_ID
FROM (
____SELECT X.*
FROM
(
--½Å±Ô½Å°í
SELECT A.UPSO_SNO REGISTER_SNO,
'134' REGISTER_GBN,
A.ATCL_PRD_SNO ATCL_PRD_SNO,
A.STDT HIST_DATE,
'' HIST_ITEM_CODE,
'' HIST_BEFO,
'½Å±Ô½Å°í' HIST_AFFT,
B.NM HIST_MAN_NAME,
B.POSIT HIST_MAN_DUTY,
A.MW_TAKE_NO MW_TAKE_NO
FROM CNTTNFATCL A, CNTTNCUSER B
WHERE A.WRKR_ID = B.USR_ID
) X ORDER BY 1,3,4,5 ) A
WHERE NVL(A.HIST_BEFO, ' ') <> NVL(A.HIST_AFFT, ' ')
AND A.ATCL_PRD_SNO < 100000
);
¡á[Âü°í4_2_2] ´ÙÁß°ÇÀÇ DELETE
DELETE FROM TNRGTMGD
WHERE ROWID IN
( SELECT A.ROWID
FROM____ TNRGTMGD A, TNRGTMGD B
WHERE A.SF_TEAM_CODE || A.WRK_CAT|| A.MG_REG_NO || SUBSTR (A.RGT_MBD_REG_NO,1,7)||'******'
= B.SF_TEAM_CODE || B.WRK_CAT|| B.MG_REG_NO || SUBSTR (B.RGT_MBD_REG_NO,1,7)||'******'
AND A.ROWID < B.ROWID
);