ORACLE SQL 숫자 처리 함수는 아래와 같이 있다. ROUND(), TRUNC(), CEIL(), FLOOR(), MOD() SELECT ROUND(45.923) --46 ,ROUND(45.923, 1) --45.9 ,ROUND(45.923, -1) --50 FROM dual; SELECT TRUNC(45.923) --46 ,TRUNC(45.923, 1) --45.9 ,TRUNC(45.923, -1) --50 FROM dual; SELECT CEIL(45.923), FLOOR(45.923) --46 / 45 FROM dual; --참고 깃허브 line.304~ https://github.com/sblee1031/Kosta/blob/main/ORACLE_DB_THEOTY/Oracle_DB.txt