Re: smashed by a problem: query to groupped hierarchical data

From: T-BAG <T-BAG_at_prisonbreak.invalid.com>
Date: Sat, 28 Jul 2007 02:06:24 +0200
Message-ID: <011b60c4$0$1610$c3e8da3@news.astraweb.com>

DA Morgan wrote:
>
> Post your code and name your version.
>
> My first thought is that the data needs to be normalized but it is late
> and I don't have the time right now to give it the attention it needs.

Hello,

the Oracle version is 10g2. Even if your first thought about normalization is right I can't influence the database; I can only query the database.

As far as code is concerned I haven't got any reasonable results. I am stuck with this problem. You can see Michel Cadot's reply in this thread. I have some problems running his query, but if it is right it'd be the right solution.

Thank you,
T-BAG Received on Fri Jul 27 2007 - 19:06:24 CDT