How to check if a column value contains integers in oracle [duplicate]

Question

Need a query that has to check whether resulting columns have integer.

Answer 1

First you must know if the value is a number. If it is in a column of type number you don't have to worry about that. To check if the value is an integer you can use the trunc function. This will take the decimal values off.

if trunc(value)= value then
   -- we have an integer
else
   -- we don't
end if;