hey dave, sorry for replying late.

i tested it with the same logic but in a different way. it worked. also i tried it using cursors too. that also worked....

thanks for replying dave.....

Actually I have used recursive queries with some different scenarios in hierarchies. But here the case is little different i have to count all nodes, for this...