How to Convert Number to Integer in Oracle?

How to Convert Number to Integer in Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

There are two ways to convert a number to an integer in Oracle. The following are the examples.

1. Convert a Number to Integer Using TRUNC Function in Oracle

SELECT TRUNC (9.387) to_int FROM DUAL;

Output

TO_INT
----------
9
1 row selected.

2. Convert Using CAST Function in Oracle

SELECT CAST (9.33 AS INTEGER) int FROM DUAL;

Output

INT
----------
9
1 row selected.

See also: