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!

range to fetch doubt

639997Mar 26 2009 — edited Mar 27 2009
create table a
(
cont_number number,
range_from number,
range_to number
)
/
insert into a values (1,0,100);
insert into a values (2,0,100);
insert into a values (3,0,100);
insert into a values (4,0,1000);
insert into a values (5,0,100);
insert into a values (6,0,100);
/
i want the output shoulld be displayed as
1-2-3   0  100
4-4      0  1000
5-6      0  100
my version is 9.2

thanks in advance
caps
This post has been answered by Frank Kulash on Mar 26 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2009
Added on Mar 26 2009
11 comments
1,268 views