How to obtain an integer from a decimal number in Oracle

SQL> select Ceil (23.33) from dual;

Ceil (23.33)
-----------
24

Elapsed: 00:00:00. 30
SQL> select role (23.33) from dual;

Round (23.33)
------------
23

Elapsed: 00:00:00. 30

 

 

 

SQL> select floor (12.23) from dual;

Floor (12.23)
------------
12

SQL> select trunc (12.23) from dual;

Trunc (12.23)
------------
12

 

 

Select round (2.34) from dual;

2

Select round (2.34, 0) from dual;

2

The second parameter of round defaults to 0, which is an integer.

 

 

Round () is rounding, not an integer ..
Ceil () is a forward integer, and floor () is a trailing integer ..
Trunc () is also the end, but it can specify the number of decimal places. If it is not specified, it is an integer, so it is correct ..