Re: sql question - hierarchy
Date: Tue, 25 Mar 2003 22:17:48 +0100
Message-ID: <b5qgv4$8tqo$1_at_as201.hinet.hr>
> > I tried with CONNECT BY clause but I couldn't get the desired result.
> > Is it possible to write an SQL query returning the result described
above?
>
> Yes, it is possible. But I have a suspicion that this is your homework,
> so, unless you prove otherwise, you'll have to figure it out yourself -
it's
> actually pretty easy.
>
Actually, I have solved the problem, using function that is returning
[Quoted] [Quoted] master_org_id of currnet_org_id. What I was asking was, is there a simple
[Quoted] and better solution to solve this. Of course, without using a function,
query would be faster and better and that is the query that I'm looking for.
So, if you have a that kind of solution, please post it, otherwise, please
don't write answers like this one...
Thanks....
Received on Tue Mar 25 2003 - 22:17:48 CET