Oracle Mathematical Correlation Function Summary _oracle

This article summarizes the Oracle mathematical correlation functions. Share to everyone for your reference, specific as follows:

1. Absolute value: ABS ()

Select ABS ( -2) value from dual;

2. Take the whole function (big): Ceil ()

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

3. Take the whole function (small): Floor ()

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

4. Take the whole function (intercept): Trunc ()

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

5. Rounding: Round ()

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

6. Take the square: power (m,n)

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

7. Square Root: SQRT ()

Select sqrt value from dual; (4)

8. Take random number: Dbms_random (minvalue,maxvalue)

Select Sys.dbms.random.value (0,1) value from dual;

9. Take symbol: 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. Minimum value for collection: least (value)

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

12. Processing null value: NVL (null value, in place of value)

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

13. Character sequence: ASCII ()

Select ASCII (a) value from dual;

14. Ordinal character: Chr ()

Select Chr () value from dual;

15. Link: concat ()

Select Concat ("One", "all") value from dual; (1122)

16. Get system Time: Sysdate ()

Select Sysdate value from dual;

17. Request a Date

Select Trunc (sysdate) from dual;

18. Ask for Time

Select To_char (sysdate, "Hh24:mm:ss") from dual;

19. First Letter Capital: Initcap ()

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

I hope this article will help you with your Oracle database program design.