We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 1_1_1 || ÁýÇÕ »ý¼º ¿¹Á¦SELECT SABUNFROM INSAWHERE SABUN LIKE '201212%'ORDER BY SABUN DESC;
¡á¿¹ 1_1_2 || À¯ÇÑ ÁýÇÕÀÇ »ý¼º ¿¹Á¦SELECT SABUNFROM INSAWHERE SABUN BETWEEN '2012123101' AND '2013010501'ORDER BY SABUN DESC;
¡á¿¹ 1_1_3 || ÇÁ·ÎÁ§Æ®¿¡ Âü¿© Á¤º¸ Á¶È¸SELECT T4.PJT_NAME, TS1.SABUN, TS1.CMP_REG_NO, TS1.CMP_NAME,TS1.NAME, T3.SABUN PJT_SABUNFROM INSA_EMP_PJT T3, INSA_RECT_NOTICE T4, (SELECT T2.SABUN, T1.CMP_REG_NO, T1.CMP_NAME,T1.CMP_KIND, T2.NAME FROM INSA_COMPANY T1, INSA T2 WHERE T1.CMP_REG_NO=T2.CMP_REG_NO) TS1WHERE T3.RECT_REG_NO=T4.RECT_REG_NOAND TS1.SABUN=T3.SABUNORDER BY T3.RECT_REG_NO;
¡á¿¹ 1_1_1.4 || Â÷ÁýÇÕÀÇ ¿¹SELECT SABUN, ENG_NAME, ADDR1, JOIN_GBN_CODEFROM INSAWHERE ADDR1 LIKE '¼¿ï%'MINUSSELECT I.SABUN, I.ENG_NAME, I.ADDR1, I.JOIN_GBN_CODEFROM INSA IWHERE REGEXP_LIKE(JOIN_GBN_CODE,'(CMP|FRE|CNT)');
¡á¿¹ 1_1_1.5 || VIEW »ý¼º ¿¹Á¦SELECT T2.CMP_NAME,NVL(COUNT(T1.SABUN),'0') AS SAWON_COUNT,MAX(T2.CMP_REG_NO) AS CMP_REG_NO,MAX(T2.DIS_YN) AS DIS_YN FROM____ INSA T1, INSA_COMPANY T2WHERE T1.CMP_REG_NO(+) = T2.CMP_REG_NOGROUP BY T2.CMP_NAMEORDER BY CMP_REG_NO;