Recurrsive Sub Totals

From: Walid Alkaakati <Walid.Alkaakati_at_astrolabeit.com>
Date: Wed, 31 Mar 2004 08:43:11 +0200
Message-ID: <OF2FCCF2FA.B0320A96-ON42256E68.0024ABE3-C2256E68.0024E9F2@astrolabeit.com>

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_at_freelists.org 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

Received on Tue Mar 30 2004 - 23:40:04 CST