We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 1_2_18 || ¿¡·¯¹ß»ý ¿¹Á¦_1SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM, T3.ACAD_ABILITYFROM TABLE_1 T1, TABLE_2 T2, TABLE_3 T3WHERE T1.SABUN = T2.SABUN(+) AND T2.ACAD_ABILITY(+) = '´ëÁ¹' AND T2.ACAD_ABILITY(+) = T3.ACAD_ABILITY(+);
¡á¿¹ 1_2_19 || ¿¡·¯¹ß»ý ¿¹Á¦_2SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM, T3.ACAD_ABILITYFROM TABLE_1 T1, TABLE_2 T2, TABLE_3 T3WHERE T1.SABUN = T2.SABUN(+) AND T2.ACAD_ABILITY(+) = '´ëÁ¹' AND T2.ACAD_ABILITY(+) = T3.ACAD_ABILITY;
¡á¿¹ 1_2_20 || OUT JOINÀÇ ¿Ã¹Ù¸¥ ¿¹ 1SELECT TT2.SABUN, TT2.ACAD_ABILITY, TT2.MAJOR_STUDY, TT2.GRAT_YM, TT3 .GRADE_NUM, DECODE(TT3.GRADE_NUM, NULL, 100, TT3.GRADE_NUM) AS T_GRADE_NUMFROM TABLE_2 TT2, TABLE_3 TT3WHERE TT2.ACAD_ABILITY = TT3.ACAD_ABILITY(+);
¡á¿¹ 1_2_21 || OUT JOINÀÇ ¿Ã¹Ù¸¥ ¿¹ 2SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM, T2.ACAD_ABILITY, T2.GRADE_NUM, T2.T_GRADE_NUMFROM TABLE_1 T1, ( SELECT TT2.SABUN, TT2.ACAD_ABILITY, TT2.MAJOR_STUDY, TT2.GRAT_YM, TT3.GRADE_NUM, DECODE(TT3.GRADE_NUM,NULL,100,TT3.GRADE_NUM) AS T_GRADE_NUM FROM TABLE_2 TT2, TABLE_3 TT3 WHERE TT2.ACAD_ABILITY = TT3.ACAD_ABILITY(+) ) T2WHERE T1.SABUN = T2.SABUN(+);