We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 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 DMLINSERT INTO CHAPTER_1 (SABUN, NAME, AGE, PHONE)VALUES ('20090102', 'È«±æµ¿', 15, '01063302151');
¡á¿¹ 4_2_11 || Å×À̺íÀÇ ¸ðµç Ä÷³¿¡ µ¥ÀÌÅÍ INSERT ÇÏ´Â SQLINSERT 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_STUDYFROM CHAPTER_1 T1, CHAPTER_2 T2WHERE 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 T2WHERE 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.ROWIDFROM INSA T1WHERE 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_1WHERE SABUN = '20090102';