We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 4_1_1 || µ¥ÀÌÅÍ º° ROWID Á¶È¸____SELECT ROWID, T1.* FROM INSA T1;
¡á¿¹ 4_1_2 || ROWID¸¦ ÀÌ¿ëÇÑ DML ½ÇÇà ¿¹Á¦UPDATE PRODUCT_MAST A --»óÇ°¸¶½ºÅÍ »óÇ°Äڵ庸Á¤ÀÛ¾÷SET A.CP_CD = 'ZZZZZ'WHERE ROWID IN ( SELECT A.ROWID FROM PRODUCT_MAST A, CONT_PROVIDER B WHERE A.CP_CD = B.CP_CD(+) AND A.CP_GB = B.CP_GB(+) AND B.CP_CD IS NULL );
UPDATE PRODUCT_MAST A --»óÇ°¸¶½ºÅÍ ÃâÆǻ纸Á¤ÀÛ¾÷SET A.CP_CD1 = 'ZZZZZ'WHERE ROWID IN ( SELECT A.ROWID FROM PRODUCT_MAST A, CONT_PROVIDER B WHERE A.CP_CD1 = B.CP_CD(+) AND A.CP_GB1 = B.CP_GB(+) AND B.CP_CD IS NULL );
DELETE --ºñ±³ °ª ÁßÀÇ Áߺ¹ °ªÀ» Á¦°ÅÇÑ´Ù.FROM RGTMGDWHERE ROWID IN ( SELECT A.ROWID FROM RGTMGD A, RGTMGD B WHERE A.TEAM_CODE||A.WRK_CAT||A.REG_NO||SUBSTR(A.MBD_REG_NO,1,7)||'******' = B.TEAM_CODE||B.WRK_CAT||B.REG_NO||SUBSTR(B.MBD_REG_NO,1,7)||'******' AND A.ROWID < B.ROWID);
¡á¿¹ 4_1_3 || ROWNUMÀÇ Á¶È¸SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE FROM____ INSA T1;
¡á¿¹ 4_1_4 || ROWNUM°ú SORTSELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE FROM INSA T1ORDER BY NAME;
¡á¿¹ 4_1_5 || ROWNUMÀÇ »ç¿ëSELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE FROM INSA T1WHERE ROWNUM =1;
¡á¿¹ 4_1_6 || ROWNUM»ç¿ëÀÇ À߸øµÈ ¿¹1SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODEFROM INSA T1WHERE ROWNUM > 2;
¡á¿¹ 4_1_7 || ROWNUM »ç¿ëÀÇ À߸øµÈ ¿¹2SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODEFROM INSA T1WHERE ROWNUM > 1 AND ROWNUM < 100;
¡á¿¹ 4_1_8 || ROWNUM »ç¿ëÀÇ ¿Ã¹Ù¸¥ ¿¹SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODEFROM INSA T1WHERE ROWNUM >= 1 AND ROWNUM < 100;