Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find the range of number between two columns.

mlov83Jul 12 2012 — edited Jul 12 2012
I have a table with two columns Column1 and column2
Like such
create table testTable (column1 number(15), column2 number(15));
 
 insert into testTable values (1,5);
I need to find the numbers between column 1 and column 2 including the column 1's number and column's 2 number.

Can someone point me in the right direction.

so my answer set should be
 1,2,3,4,5
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2012
Added on Jul 12 2012
4 comments
1,066 views