Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_09_11.sql

Created March 8, 2017 12:34
Show Gist options
  • Save kimki1124/43110f2952a8ae4426717a5126ebb7ae to your computer and use it in GitHub Desktop.
Save kimki1124/43110f2952a8ae4426717a5126ebb7ae to your computer and use it in GitHub Desktop.
Download ZIP
[ORACLE] SQL 함수 (날짜 함수, 변환 함수, NULL 관련 함수, 기타 함수)
Raw
oracle_09_11.sql
SELECT EMPLOYEE_ID, NVL2(COMMISSION_PCT, SALARY + (SALARY * COMMISSION_PCT), SALARY) AS SALARY2
FROM EMPLOYEES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment