Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_09_14.sql

Created March 8, 2017 12:35
Show Gist options
  • Save kimki1124/bdd10d3132ed4fe53dcf18880c933507 to your computer and use it in GitHub Desktop.
Save kimki1124/bdd10d3132ed4fe53dcf18880c933507 to your computer and use it in GitHub Desktop.
Download ZIP
[ORACLE] SQL 함수 (날짜 함수, 변환 함수, NULL 관련 함수, 기타 함수)
Raw
oracle_09_14.sql
SELECT COUNT(*)
FROM EMPLOYEES
WHERE NVL(COMMISSION_PCT, 0) < 0.2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment