Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_09_15.sql

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