1. EMP Å×ÀÌºí¿¡¼­ À̸§,ÀÔ»çÀÏ,ÀÔ»çÀϷκÎÅÍ 6°³¿ù ÈÄ µ¹¾Æ¿À´Â ¿ù¿äÀÏÀ» ±¸ÇÏ¿© Ãâ·ÂÇÏ´Â SELECT ¹®ÀåÀ» ±â¼úÇϽÿÀ. select ename,hiredate,next_day(add_months(hiredate,6),2) "ÀÔ»çÈÄ6°³¿ù",to_char(next_day(add_months(hiredate,6),2),'day') "¿äÀÏ" from emp; 2. EMP Å×ÀÌºí¿¡¼­ À̸§,ÀÔ»çÀÏ, ÀÔ»çÀϷκÎÅÍ ÇöÀç±îÁöÀÇ ¿ù¼ö,±Þ¿©, ÀÔ»çÀϺÎÅÍ ÇöÀç±îÁöÀÇ ±Þ¿©ÀÇ ÃѰ踦 Ãâ·ÂÇÏ´Â SELECT ¹®ÀåÀ» ±â¼úÇϽÿÀ. select ename,hiredate,trunc(months_between(sysdate,hiredate)),sal,sal*trunc(months_between(sysdate,hiredate)) from emp; 3. EMP Å×ÀÌºí¿¡¼­ ¸ðµç »ç¿øÀÇ À̸§°ú ±Þ¿©(15ÀÚ¸®·Î Ãâ·Â ÁÂÃøÀÇ ºó °÷Àº ¡°*¡±·Î ´ëÄ¡)¸¦ Ãâ·ÂÇÏ´Â SELECT ¹®ÀåÀ» ±â¼úÇϽÿÀ. select lpad(ename,15,'*'),lpad(sal,15,'*') from emp; 4. EMP Å×ÀÌºí¿¡¼­ »ç¿øÀÇ ±Þ¿©¿Í »ç¿øÀÇ ±Þ¿© ¾ç¸¸Å­ ¡°*¡±¸¦ Ãâ·ÂÇÏ´Â SELECT ¹®ÀåÀ» ÀÛ¼ºÇÏ¿©¶ó. ´Ü ¡°*¡±´Â 100À» ÀǹÌÇÑ´Ù. Employee and their salary ----------------------------------------------------------------- KING ************************************************** BLAKE **************************** CLARK ************************ JONES ***************************** MARTIN ************ ALLEN **************** TURNER *************** . . . . . . . . . . select rpad(ename,10)||rpad('*',trunc(sal/100),'*') "Employee and their salary" from emp; 5.EMPÅ×ÀÌºí¿¡¼­ »ç¿øµéÀÇ À̸§°ú ÀÔ»ç¿äÀÏÀ» Ãâ·ÂÇϽÿÀ(´Ü,¿ù-È­-¼ö-¸ñ...¼øÀ¸·Î Á¤·ÄÇÏ¿© Ãâ·Â) select ename,hiredate,to_char(hiredate,'dy') "ÀÔ»ç¿äÀÏ" from emp order by to_char(hiredate-1,'d'); 6. EMP Å×ÀÌºí¿¡¼­ 20¹ø ºÎ¼­Áß ±Þ¿© ¾Õ¿¡ $¸¦ »ðÀÔÇÏ°í 3ÀÚ¸®¸¶´Ù ,¸¦ Ãâ·ÂÇÏ¿©¶ó. select ename,to_char(sal,'$999,999') from emp where deptno=20; 7. February 22, 1981¿¡ ÀÔ»çÇÑ »ç¿øÀÇ À̸§, ¾÷¹«, ÀÔ»çÀÏÀÚ¸¦ Ãâ·ÂÇÏ¿©¶ó.(³¯Â¥°ü·Ã ÇÔ¼ö¸¦ ÀÌ¿ëÇؼ­...) select ename,job,hiredate from emp where hiredate=to_date('02 22, 1981','mm dd,yyyy'); select ename,job,hiredate from emp where to_char(hiredate,'rrrr/mm/dd')='1981/02/22'; 8.EMP Å×ÀÌºí¿¡¼­ 1982³â ÀÌÀü¿¡ ÀÔ»çÇÑ »ç¿øµéÀÇ À̸§,ÀÔ»çÀÏÀÚ¸¦ Ãâ·ÂÇϽÿÀ.(³¯Â¥°ü·Ã ÇÔ¼ö¸¦ ÀÌ¿ëÇؼ­...) select ename,hiredate from emp where to_char(hiredate,'yyyy')<'1982'; select ename,hiredate from emp where hiredate