Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_09_12.sql

Created March 8, 2017 12:34
Show Gist options
  • Save kimki1124/e1c9932a3f9c47457b2775d2e654e382 to your computer and use it in GitHub Desktop.
Save kimki1124/e1c9932a3f9c47457b2775d2e654e382 to your computer and use it in GitHub Desktop.
Download ZIP
[ORACLE] SQL 함수 (날짜 함수, 변환 함수, NULL 관련 함수, 기타 함수)
Raw
oracle_09_12.sql
SELECT EMPLOYEE_ID, SALARY, COMMISSION_PCT,
COALESCE(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