Inverse hierarchical queries

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
France Received on Thu Sep 23 1999 - 04:16:19 CDT