| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Flattening a time-based tree structure
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
 |
 |