SQL Server equivalent in Oracle

Question

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.

See http://stackoverflow.com/questions/3564283 . (Not quite the same question, but the accepted answer should answer your question.) — , Apr 24 '13 at 07:38
Does [this](http://stackoverflow.com/questions/5653423/how-do-i-use-variables-in-oracle-sql-developer) help ? — A.B.Cade, Apr 24 '13 at 08:03

Devart · Accepted Answer · 2013-04-24T11:15:12.970

1

Try this one -

CREATE TABLE tbl (ID NUMBER);
INSERT INTO tbl VALUES (100);
INSERT INTO tbl VALUES (10);

DEFINE n = 100;

SELECT * 
FROM tbl 
WHERE id BETWEEN &n AND &n + 50;

proff

You can try to run this script in dbForge Studio for Oracle (trial or free express version).

edited Apr 24 '13 at 11:15

answered Apr 24 '13 at 08:03

Devart

119,203
23
166
186

SQL Server equivalent in Oracle

1 Answers1