We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 1_2_1 || Cartesian JoinÀÇ SQLÀû¿ë¿¹SELECT I.SABUN, I.JOIN_DAY, E.RECT_REG_NOFROM INSA I, INSA_EMP_PJT EORDER BY E.RECT_REG_NO DESC;
¡á¿¹ 1_2_2 || Dual Å×À̺íSELECT * FROM DUAL;
¡á¿¹ 1_2_3 || Dual Å×À̺í È°¿ë 1SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUALUNIONSELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL;
¡á¿¹ 1_2_4 || Dual Å×À̺í È°¿ë 2SELECT GREATEST('1996','1222') FROM DUAL;SELECT LEAST('1996','1222') FROM DUAL;SELECT INSTR('CORPORATE FLOOR','OR',3,2) "INSTRING" FROM DUAL;SELECT 'CHARACTER STRING IN QUOTES'||'AAA'||'AAA' RESULT FROM DUAL;
¡á¿¹ 1_2_5 || COPY_T Å×ÀÌºí »ý¼º____CREATE TABLE____ COPY_TASSELECT ROWNUM AS COL_1, TO_CHAR(ROWNUM,'009') AS COL_2FROM CMM_CODE_DETAILWHERE ROWNUM < 101;
¡á¿¹ 1_2_6 || Cartesian JoinÀÇ SQLÀû¿ë¿¹SELECT DECODE(COL_1,1,SABUN,'ÇÕ°è')AS SABUN ,DECODE(COL_1,1,NAME,'ÇÕ°è') AS NAME ,COUNT(DECODE(COL_1,1,NAME,'ÇÕ°è')) AS TOTALFROM INSA T1, COPY_T T2WHERE T1.JOIN_GBN_CODE = 'RGL' --Á¤Á÷ AND T2.COL_1 < 3GROUP BY DECODE(COL_1,1,SABUN,'ÇÕ°è') ,DECODE(COL_1,1,NAME,'ÇÕ°è')ORDER BY SABUN;
¡á¿¹ 1_2_7 || Cartesian JoinÀÇ SQLÀû¿ë¿¹SELECT *FROM ( SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL UNION SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL ) T1, ( SELECT '20090101' AS SABUN, 'A' AS GUBUN FROM DUAL UNION SELECT '20090102' AS SABUN, 'B' AS GUBUN FROM DUAL ) T2;
¡á¿¹ 1_2_8 || īƼÁ¯ Á¶ÀÎÀÌ ¾Æ´Ñ »ç¹øÀ¸·Î Á¶ÀÎµÈ ½ÇÇàÄõ¸®SELECT *FROM ( SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL UNION SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL ) T1, ( SELECT '20090101' AS SABUN, 'A' AS GUBUN FROM DUAL UNION SELECT '20090102' AS SABUN, 'B' AS GUBUN FROM DUAL ) T2WHERE T1.SABUN = T2.SABUN;
¡á¿¹ 1_2_9 || 3°³ÀÇ Å×À̺í·Î Á¶ÀÎµÈ ½ÇÇàÄõ¸®SELECT DECODE(NO,'02',T1.SABUN,'ÇÕ°è') ,DECODE(NO,'02',T1.NAME,'-') ,DECODE(NO,'02',T2.GUBUN,'-') ,COUNT(T2.GUBUN)FROM ( SELECT '20090101' AS SABUN, 'ÀÌÈ£»ó' AS NAME FROM DUAL UNION SELECT '20090102' AS SABUN, 'È«±æµ¿' AS NAME FROM DUAL ) T1, ( SELECT '20090101' AS SABUN, 'A' AS GUBUN FROM DUAL UNION SELECT '20090102' AS SABUN, 'B' AS GUBUN FROM DUAL ) T2, ( SELECT '01' AS NO FROM DUAL UNION SELECT '02' AS NO FROM DUAL ) T3WHERE T1.SABUN = T2.SABUNGROUP BY DECODE(NO,'02',T1.SABUN,'ÇÕ°è') ,DECODE(NO,'02',T1.NAME,'-') ,DECODE(NO,'02',T2.GUBUN,'-')