¡á¿¹ 4_2_9 || µÎ ³¯Â¥¸¦ ÀÔ·Â ¹Þ¾Æ ±× »çÀÌÀÇ ³â ¿ù ÀÏ »ý¼º
SELECT TO_CHAR(((TO_DATE(20130125,'YYYYMMDD')-1) - (-1*NO)),'YYYYMMDD') SLE_YMD
FROM (SELECT ROWNUM AS NO FROM A_PGM_AUTH)
WHERE NO < (SELECT ((TO_DATE(20130130,'YYYYMMDD')+1) - (TO_DATE(20130125,'YYYYMMDD')-1)) IL_SU FROM DUAL);
¡á¿¹ 4_2_10 || ±âº»ÀûÀÎ INSERT DML
INSERT INTO CHAPTER_1 (SABUN, NAME, AGE, PHONE)
VALUES ('20090102', 'È«±æµ¿', 15, '01063302151');
¡á¿¹ 4_2_11 || Å×À̺íÀÇ ¸ðµç Ä÷³¿¡ µ¥ÀÌÅÍ INSERT ÇÏ´Â SQL
INSERT INTO TABLE¸í
VALUES ( value1, value2, ¡¦.valueN );
¡á¿¹ 4_2_12 || »õ·Î¿î Å×ÀÌºí »ý¼º°ú µ¿½Ã¿¡ µ¥ÀÌÅÍ INSERT
--SQL1
____CREATE TABLE____ IMSI_TABLE
AS SELECT T1.SABUN SABUN , T1.NAME NAME,
NVL(T2.ACAD_ABILITY, '-') AS ACAD_ABILITY,
NVL(T2.MAJOR_STUDY, '-') MAJOR_STUDY
FROM CHAPTER_1 T1, CHAPTER_2 T2
WHERE T1.SABUN = T2.SABUN(+);
--SQL2
____CREATE TABLE____ IMSI_TABLE (SABUN, NAME, ACAD_ABILITY, MAJOR_STUDY)
AS SELECT T1.SABUN, T1.NAME, NVL(T2.ACAD_ABILITY,'-'), NVL(T2.MAJOR_STUDY,'-')
FROM CHAPTER_1 T1, CHAPTER_2 T2
WHERE T1.SABUN = T2.SABUN(+);
¡á¿¹ 4_2_13 || ±âº» UPDATE Äõ¸®¿Í µ¥ÀÌÅÍ Á¶È¸
UPDATE TABLE_1
SET AGE = '23', PHONE='01063307700'
WHERE NAME = 'È«±æµ¿';
¡á¿¹ 4_2_14 || ´ÙÁß UPDATE SQL¹®
UPDATE PRODUCT_MAST A
SET (A.LINK_CLASS ,A.CP_CD, A.CP_CD1)
= (SELECT B.LINK_CLASS, B.CP_CD, B.CP_CD1
FROM PRODUCT_MAST_NEW B
WHERE B.BARCODE = A.BARCODE
);
¡á¿¹ 4_2_15 || ROWID üũ
SELECT T1.ROWID
FROM INSA T1
WHERE SABUN = '2012010101';
¡á¿¹ 4_2_16 || ROW ID¸¦ ÀÌ¿ëÇÑ ´ÙÁß UPDATE Äõ¸®¿Í µ¥ÀÌÅÍ Á¶È¸ (Å×À̺í È®ÀÎ)
UPDATE PRODUCT_MAST
SET CP_CD ='ZZZZZ', CP_CD1 ='ZZZZZ', LINK_CLASS = ''
WHERE ROWID IN (
SELECT A.ROWID
FROM PRODUCT_MAST A, PRODUCT_MAST_NEW B
WHERE A.BARCODE = B.BARCODE(+)
AND B.BARCODE IS NULL
);
¡á¿¹ 4_2_17 || EXISTS¸¦ ÀÌ¿ëÇÑ ´ÙÁß UPDATE Äõ¸®¿Í µ¥ÀÌÅÍ Á¶È¸ (Å×À̺í È®ÀÎ)
UPDATE KFA2003.IFD_GOODS_INGR AA
SET AA.INGR_CODE = (SELECT INGR_CODE_NEW
FROM INGR_CODE_2009CONV BB
WHERE BB.USE_YN = '2' --»èÁ¦
AND AA.INGR_CODE = BB.INGR_CODE_OLD
)
WHERE EXISTS (SELECT 1
FROM INGR_CODE_2009CONV BB
WHERE BB.USE_YN = '2' --»èÁ¦
AND AA.INGR_CODE = BB.INGR_CODE_OLD
);
¡á¿¹ 4_2_18 || ±âº» DELETE Äõ¸®¿Í µ¥ÀÌÅÍ Á¶È¸
DELETE TABLE_1
WHERE SABUN = '20090102';