Hierarchical Query

From: Huascar Espinoza <hespinoza_at_superele.gov.bo>
Date: Mon, 28 Jun 2004 12:22:21 -0400
Message-ID: <B2DC72F71B99474B8CCA0C3611AAC2A82203C8@correo.super.gov.bo>

Hi!  

I need to get the ROOT data of a query CONNECT BY PRIOR (on 9i). I can get this data by SUBSTR and SYS_CONNECT_BY_PATH, but the query is to slow. Are there another ways? I need this data to GROUP BY and summarize another field for all connected registers (SUM(Field X) all registers with the same ROOT).  

Thank you,  

Huáscar

---

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 Mon Jun 28 2004 - 11:19:05 CDT