자주쓰는 ORACLE DB 문법

Reading time ~1 minute

ORACLE DB

ROUND 함수

SELECT ROUND((((2000-2043.75)/2043.75) * 100), 2)
	FROM DUAL;

ABS 함수

SELECT ABS(ROUND((((2000-2043.75)/2043.75) * 100), 2))
	FROM DUAL;