I'm new in Oracle database. What I need is equivalent query in Oracle like this example from SQL Server (reading results in Management Studio). On Oracle side, I'm using Golden6 from Benthic Software.
declare @n integer
set @n = 100;
select * from table where id >= @n and id <= @n + 50
Thank you.