오라클 함수정리 2탄
SELECTEMPLOYEE_ID, FIRST_NAME || ' ' || LAST_NAME AS NAME , SALARY , DEPARTMENT_ID FROM EMPLOYEES WHERE SUBSTR(LAST_NAME, 1, 1) = 'K'; SELECTEMPLOYEE_ID, FIRST_NAME || ' ' || LAST_NAME AS NAME , SALARY , DEPARTMENT_ID FROM EMPLOYEES WHERE LOWER(SUBSTR(LAST_NAME, 1, 1)) = 'k' AND SALARY >= 10000 ORDER BY EMPLOYEE_ID DESC-- SUBSTR함수 (문자열, 위지, 갯수) : 지정된 길이의 문자열을 추출-- 내림차순 -> DESC-- LOWER와 UPPER 함수를..
더보기
