Hi All,

Can't we achive retrive all the parents of group of nodes from a tree
in single row, without using the analytical functions? For some reasons the query with the analytical functions is taking more time to execute. Please read the following message. Thanks for any help.
------------------------------------------------------------------
Thank you JMODIC for your query.

When I try the padder's query(which has the analytical functions),
the performance is very slow for large number of nodes(almost 1967 nodes) in the "in clause".
Then I have tried your query without analytical functions.
But I have one problem your query, that the nodes in the "IN clause" are not always level 4 nodes,
those may be any level from 4 to 1.

If the node in the "IN clause" is 4 then it returns 4,3,2,1.
If the node in the "IN clause" is 3 then it returns 3,2,1.
If the node in the "IN clause" is 2 then it returns 2,1.
If the node in the "IN clause" is 1 then it returns 1.

For the above scenario's CEIL(ROWNUM/4) doesn't work to group the results.


How we can acheive this without using the analytical functions?
----------------------------------------------------------------------


Thanks in advance.


regards,
Srinivas Medukonduru