By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
SELECT ROUND(455.23456,-3) FROM DUAL;
| ROUND(455.23456,-3) |
|---|
| 0 |
SELECT ROUND(455.23456,-2), ROUND(455.23456,-1) FROM DUAL;
| ROUND(455.23456,-2) | ROUND(455.23456,-1) |
|---|---|
| 500 | 460 |