Orace: Number Built Function

3. Number Function

1. SELECT ABS(-56) FROM DUAL;

2. SELECT ABS(+56) FROM DUAL;

3. SELECT MOD(56,6) FROM DUAL;

4. SELECT MOD(17,4) FROM DUAL;

5. SELECT MOD(23,2) FROM DUAL;

6. SELECT POWER(2,2) FROM DUAL;

7. SELECT POWER(5,3) FROM DUAL;

8. SELECT POWER(8,8) FROM DUAL;

9. SELECT SQRT(64) FROM DUAL;

10. SELECT SQRT(8) FROM DUAL;

11. SELECT SQRT(23) FROM DUAL;

12. SELECT SIGN(-98) FROM DUAL;

13. SELECT SIGN(98) FROM DUAL;

14. SELECT CEIL(86.50) FROM DUAL;

15. SELECT CEIL(86.23) FROM DUAL;

16. SELECT CEIL(86.75) FROM DUAL;

17. SELECT FLOOR(86.50)FROM DUAL;

18. SELECT FLOOR(86.23) FROM DUAL;

19. SELECT FLOOR(86.75) FROM DUAL;

20. SELECT ROUND(86.50)FROM DUAL;

21. SELECT ROUND(86.23) FROM DUAL;

22. SELECT ROUND(86.75) FROM DUAL;

23. SELECT TRUNC(86.50) FROM DUAL;

24. SELECT TRUNC(86.23) FROM DUAL;

25. SELECT TRUNC(86.75) FROM DUAL;