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

Home -> Community -> Usenet -> c.d.o.server -> Re: Flattening a time-based tree structure

Re: Flattening a time-based tree structure

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 9 Aug 2005 10:20:35 -0700
Message-ID: <1123608035.145878.280210@g47g2000cwa.googlegroups.com>

Catalin Pitis wrote:
> Yes. For example, from 1/1/2003 to 31/12/2003 U1 is the parent of U2,
> and from 1/1/2004 to 31/12/2004, U2 is the parent of U1.
>
> Catalin

Then I'm not sure I understand why CONNECT BY doesn't work, if you can keep the hierarchy to one timeframe. IOW you'll have both the CONNECT BY clause and the WHERE clause.

Does that help?
  Ed. Received on Tue Aug 09 2005 - 12:20:35 CDT

Original text of this message

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