오라클 Day 2

📝 목차

Chapter 06 오라클 함수

---

Chapter 06 오라클 함수

📌 문제 1

SELECT EMPNO,
	   RPAD(SUBSTR(EMPNO, 1, 2), 4, '*') AS MASKING_EMPNO,
	   ENAME,
	   RPAD(SUBSTR(ENAME, 1, 1), LENGTH(ENAME), '*') AS MASKING_ENAME
FROM EMP
WHERE LENGTH(ENAME) >= 5 AND LENGTH(ENAME) < 6;

📌 문제 2

SELECT EMPNO, ENAME, SAL,
       TRUNC(SAL / 21.5, 2) AS DAY_PAY,
       ROUND(SAL / 21.5 / 8, 1) AS TIME_PAY
FROM EMP;

📌 문제 3

SELECT EMPNO, ENAME, HIREDATE,
       TO_CHAR(NEXT_DAY(ADD_MONTHS(HIREDATE, 3), '월요일'), 'YYYY-MM-DD') AS R_JOB,
       NVL(TO_CHAR(COMM), 'N/A') AS COMM
FROM EMP;

📌 문제 4

SELECT EMPNO, ENAME, MGR,
CASE 
	WHEN MGR IS NULL THEN '0000'
	WHEN SUBSTR(MGR, 1, 2) = '75' THEN '5555'
	WHEN SUBSTR(MGR, 1, 2) = '76' THEN '6666'
	WHEN SUBSTR(MGR, 1, 2) = '77' THEN '7777'
	WHEN SUBSTR(MGR, 1, 2) = '78' THEN '8888'
	ELSE TO_CHAR(MGR)
END AS CHG_MGR
FROM EMP;

Reference

• Do it 오라클로 배우는 데이터베이스 입문