Oracle absolute value functions

1. Absolute Value: ABS ()

Select ABS (-2) value from dual;

2. Take the entire function (large): Ceil ()

Select Ceil (-2.001) value from dual; (-2)

3. Take the entire function (small): floor ()

Select floor (-2.001) value from dual; (-3)

4. Take the entire function (screenshot): trunc ()

Select trunc (-2.001) value from dual; (-2)

5. Rounding: round ()

Select round (1.234564) value from dual; (1.2346)

6. Square: Power (m, n)

Select power (4, 2) value from dual; (16)

7. Take the square root: SQRT ()

Select SQRT (16) value from dual; (4)

8. Random Number: dbms_random (minvalue, maxvalue)

Select Sys. DBMS. Random. Value (0, 1) value from dual;

9. Sign: Sign ()

Select sign (-3) value from dual ;(-)

10, take the maximum value of the set: greatest (value)

Select greatest (-1, 3, 5, 7, 9) value from dual; (9)

11. Take the minimum value of the set: Least (value)

Select least (-1, 3, 5, 7, 9) value from dual; (-1)

12. process null values: nvl (null value, instead of value)

Select nvl (null, 10) value from dual; (10)

13. Search for the character serial number: ASCII ()

Select ASCII (a) value from dual;

14. ordinal character: CHR ()

Select CHR (97) value from dual;

15. Link: Concat ()

Select Concat ("11", "22") value from dual; (1122)

16. Obtain the system time: sysdate ()

Select sysdate value from dual;

17. Calculate the date

Select trunc (sysdate) from dual;

18. Time

Select to_char (sysdate, "hh24: mm: SS") from dual;

19. uppercase letters: initcap ()

Select initcap (ABC def GHI) value from dual; (ABC def GHI)