fabriziodb (12/2/2016)
CELKO (11/30/2016)
>> I need a query to find out all orphans over a hierarchical table <<``
I never heard this term before, and I wrote the standards. I think you are trying to find some trees not connected to a particular root node. Is that correct? You are trying to get all of his into one tree.
I'm sorry, i transaleted from Italian, i don't know what is the right term to indicate a node without any parent.
Don't worry, most people with real world knowledge can understand what you mean with orphans. Only theorists won't understand and will want to enforce their terminology.