Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Select grouping ranges of records

Select grouping ranges of records

From: lsouzaf <lsouzaf_at_yahoo.com>
Date: 29 Nov 2003 05:52:22 -0800
Message-ID: <38bbe165.0311290552.4a93d93@posting.google.com>


I´m designing a new report and I have a query that returns something like :    

   1,2,3,4,5,9,10,11,15,16,17,20,24,25.    

   I need to print this result like this:

   From 1 to 5
   From 9 to 11
   From 15 to 17

        20
   From 24 to 25

   Does anyone have an idea of how can this be done ? Received on Sat Nov 29 2003 - 07:52:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US