¡á¿¹ 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 RGTMGD
WHERE 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°ú SORT
SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE
FROM INSA T1
ORDER BY NAME;
¡á¿¹ 4_1_5 || ROWNUMÀÇ »ç¿ë
SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE
FROM INSA T1
WHERE ROWNUM =1;
¡á¿¹ 4_1_6 || ROWNUM»ç¿ëÀÇ À߸øµÈ ¿¹1
SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE
FROM INSA T1
WHERE ROWNUM > 2;
¡á¿¹ 4_1_7 || ROWNUM »ç¿ëÀÇ À߸øµÈ ¿¹2
SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE
FROM INSA T1
WHERE ROWNUM > 1 AND ROWNUM < 100;
¡á¿¹ 4_1_8 || ROWNUM »ç¿ëÀÇ ¿Ã¹Ù¸¥ ¿¹
SELECT ROWNUM, SABUN, NAME, ENG_NAME, JOIN_GBN_CODE
FROM INSA T1
WHERE ROWNUM >= 1 AND ROWNUM < 100;