Is there integer ranges for Where Clause?

oracle, sql

Solution

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;

Problem

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.

Original source