Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: multilevel hierarchy query

Re: multilevel hierarchy query

From: <bruce_at_aristotle.net>
Date: 17 Feb 2005 10:23:07 -0800
Message-ID: <1108664587.309966.10800@g14g2000cwa.googlegroups.com> 





If you _know_ the number of levels of the hierarchy in advance, then
this is probably the way to go.  Otherwise you're probably going to
need to resort to a recursive VBA code solution of some kind.  It would
be an intriguing exercise to combine the two, i.e., write code to
determine the actual depth of the hierarchy based on your actual data
and then actually generate the SQL from code...



Bruce
Received on Thu Feb 17 2005 - 12:23:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US