Select all numbers in a range
Hi all,
I got a tricky one.. at least.. I couldn't find a solution in google..
I have a table with a couple of tables.. it looks sometimes like
number_start, number_end, id
200 300 0
4222 4599 1
I want to make a query that returns me all the numbers between 4222 and 4599 for ID 1.. or 200 - 300 for ID 0..
So if I query for ID0 I need all the numbers between 200 and 300..
Something like;
ID number
0 200
0 201
0 202
etc
Anyone got a clue how to do this?
Alex
Subject
Views
Written By
Posted
Select all numbers in a range
5432
March 09, 2008 12:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.