Oracle 예제 문제

Oracle의 emp, dept 테이블 사용   -- 1. 덧셈연산자를 이용하여 모든 사원에 대해서 $300의 급여 인상을 계산한 후 사원의 이름, 급여, 인상된 급여를 출력하시오. select ename, sal, sal+300 as up_salfrom emp;-- 2. 사원의 이름, 급여, 연간 총 수입을 총 수입이 많은 것부터 작은 순으로 출력하시오, 연간 총수입은 월급에 12를 곱한 후 $100의 상여금을 더해서 계산하시오.select ename, sal,ysalfrom (select ename , sal, sal*12 as ysal from emp)order by ysal asc;select ename , sal, sal*12 as ysalfrom emporder by ysal as..

2024.11.24