Recurrsive Sub Totals

  • From: Walid Alkaakati <Walid.Alkaakati@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 31 Mar 2004 08:43:11 +0200

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
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:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts:

  • » Recurrsive Sub Totals