Inverse hierarchical queries
From: Yves DEBIZET <yves.debizet_at_mc2.fr>
Date: Thu, 23 Sep 1999 11:16:19 +0200
Message-ID: <37E9EFE2.1F03BE2E_at_mc2.fr>
[Quoted] The "select ;; start with ... connect by ..." is a way to describe a hierarchy starting down from a point (root to leaves).
Date: Thu, 23 Sep 1999 11:16:19 +0200
Message-ID: <37E9EFE2.1F03BE2E_at_mc2.fr>
[Quoted] The "select ;; start with ... connect by ..." is a way to describe a hierarchy starting down from a point (root to leaves).
But how to find all the parents of a node in a tree (leaf to root) in a single SQL statement ?
Thank you.
-- Yves DEBIZET mailto:yves.debizet_at_mc2.fr tel: +33 476 04 50 29 fax: +33 476 04 50 01 MC2 (http://www.mc2.fr) 4 Chemin de Malacher, ZIRST 4401 F38944 Meylan Cedex FranceReceived on Thu Sep 23 1999 - 11:16:19 CEST