Hi All, Just for my eduction (can't find it in the manuals but glad to be pointed in the right direction): what happens in a CONNECT BY PUMP operation during a hierarchical query? Many thanks for any information! Charlotte -- //www.freelists.org/webpage/oracle-l