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@(protected)
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
-----------------------------------------------------------------