DataBase/DB실습(SQL,PLSQL)

SQL연습-04함수(SCOTT)

RoarinGom 2021. 2. 21. 12:51

SELECT EMPNO, 
    SUBSTR(To_char(EMPNO),1,2)||'**' Maksing_EMPNO,
    ENAME,
    RPAD(SUBSTR(ENAME,1,1),5,'#') MASKING_ENAME
    FROM EMP;
    
SELECT EMPNO, ENAME, SAL, TRUNC(SAL/21.5,2) DAY_PAY,
  ROUND(SAL/21.5/8,1) TIME_PAY FROM EMP;
  
SELECT EMPNO, ENAME, TO_CHAR(HIREDATE,'yyyy/MM/dd') HIREDATE, TO_CHAR(NEXT_DAY(HIREDATE,'월요일'),'yyyy-MM-dd') R_JOB,
  NVL(TO_CHAR(COMM),'N/A') COMM FROM EMP;
  
SELECT EMPNO, ENAME, MGR,
  CASE
  WHEN MGR IS NULL THEN '0000'
  WHEN MGR LIKE '78%' THEN '8888'
  WHEN MGR LIKE '77%' THEN '7777'
  WHEN MGR LIKE '76%' THEN '6666'
  WHEN MGR LIKE '75%' THEN '5555'
  ELSE TO_CHAR(MGR)
  END AS CHG_MGR
  FROM EMP;