# >> Continuing Education >> Be Self Taught

How to Convert Float to Integer in Oracle

Oracle databases allow users to run searches and create data displays using Structured Query Language (SQL). Like most programming languages, SQL categorizes variables according to their properties. An integer can be any whole number such as 1 or 365, but never contains a decimal point or any fractional values. Numbers that contain decimal points and fractional values are known as float numbers in SQL. Coding can occasionally restrict functions to look for only one category of variable. Learning how to convert a float to an integer using SQL allows you to avoid syntax errors in Oracle.

Instructions

- 1
  Open Oracle. Select the "SQL Developer" tool.
- 2
  Type "SELECT CONVERT(int," without the quotation marks in the query field.
- 3
  Determine what sort of float variable you wish to convert. Enter the value of the float within the parentheses of the "CONVERT" statement if you are converting a constant float value. For example, "SELECT CONVERT(int, 4.5)" converts the value "4.5" to "5" by rounding it up.
- 4
  Use nested commands to convert a variable float value. Type "SELECT CONVERT(int, (SELECT variable FROM table))" without the quotation marks. Replace "variable" and "table" with the names of the variable and its table from your database. For example, if "variable" equals 4.2, then the command above returns "4" by rounding it down to the nearest integer.

How to Create an NPV Chart

How to Convert a JSON Number to an Integer

Be Self Taught