SELECT TRUNC(1234.5678,-2) FROM DUAL;
Answers- 1200. trunc is not a recognized built-in function name.so use select round(1234.5678,-2) from 'tablename'. this function works well.
trunc