We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡áÂü°í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_IDFROM ( ____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 ) AWHERE NVL(A.HIST_BEFO, ' ') <> NVL(A.HIST_AFFT, ' ')AND A.ATCL_PRD_SNO < 100000);
¡á[Âü°í4_2_2] ´ÙÁß°ÇÀÇ DELETEDELETE 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 );