Recurrsive Sub Totals





I have requirements  like   total sales  by areas,or total   sales   by
customer  categories ... ,these structures
areas,categories....  are of recurrsive nature  Ie.i have to  show    for
example  sales for first level  then
the detail of these sales for example


Customer  category                          sales         seq
,parent_seq
01 -Impulse                                 10000          1
       0101- Large Groccery                 3000           2           1
       0102- Gas Station                    7000           3           1

What is best way to do that  regarding   time response   and flexibility.

Any  help is appreciated.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  • » Recurrsive Sub Totals