Re: sql question - hierarchy
From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 25 Mar 2003 21:35:56 +0300
Message-ID: <b5q80o$k9l$1_at_babylon.agtel.net>
Date: Tue, 25 Mar 2003 21:35:56 +0300
Message-ID: <b5q80o$k9l$1_at_babylon.agtel.net>
[tables and desired result skipped]
> 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?
[Quoted] 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 [Quoted] actually pretty easy.
-- Vladimir Zakharychev (bob_at_dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer.Received on Tue Mar 25 2003 - 19:35:56 CET