Is there integer ranges for Where Clause?

Question

I need to check that result of expression in where clause is in range of Integers.

something lke this:

select * from table where (col1 / col2 ) in (1..8). 

With (1..8) representing a range of integers.

I mean that it must be integer, not float. So that I cant use between 1 and 8, because 1.2 will be correct.

Answer 1

You can of course do this:

select * from table where (col1 / col2 ) in (1,2,3,4,5,6,7,8);

or

select * from table where (col1 / col2 ) between 1 and 8
and mod (col1 , col2 ) = 0;

Answer 2

How about

select * 
from table
where (col1 / col2 ) BETWEEN 1 AND 8
  and (col1 / col2 ) = FLOOR(col1 / col2 )

This simply checks if the fraction is in the interval, and integer.