The following lists commonly used SQL string processing functions. Now let's take a look at the absolute value & nbsp; SQL: selectabs (-1) value & nbsp; o: selectabs (-1) valuefromdual & nbsp; 2. round (large) & nbsp; s: selectceiling (-1.001) value & nbsp; o: selectceil (-1.001) v lists commonly used SQL string processing functions, let's get started.
Absolute Value
SQL: select abs (-1) value
O: select abs (-1) value from dual
2. INTEGER (large)
S: select ceiling (-1.001) value
O: select ceil (-1.001) value from dual
3. Round (small)
S: select floor (-1.001) value
O: select floor (-1.001) value from dual
4. Round (truncation)
S: select cast (-1.002 as int) value
O: select trunc (-1.002) value from dual
5. Rounding
S: select round (1.23456, 4) value 1.23460
O: select round (1.23456, 4) value from dual 1.2346
6. e is the base power
S: select exp (1) value 2.7182818284590451
O: select exp (1) value from dual 2.71828182
7. Take the base logarithm of e.
S: select log (1, 2.7182818284590451) value 1
O: select ln (2.7182818284590451) value from dual; 1
8. Use 10 as the base logarithm.
S: select log10 (10) value 1
O: select log (10, 10) value from dual; 1
9. Square
S: select square (4) value 16
O: select power (4, 2) value from dual 16
10. Take the square root
S: select sqrt (4) value 2
O: select sqrt (4) value from dual 2
11. Evaluate the base power of any number
S: select power (3, 4) value 81
O: select power (3, 4) value from dual 81
12. Random Number acquisition
S: select rand () value
O: select sys. dbms_random.value (0, 1) value from dual;
13. Get the symbol
S: select sign (-8) value-1
O: select sign (-8) value from dual-1
---------- Mathematical functions