Question Locked
genealogy Query
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi,
i need a query for a particular process.
Table spec:
ChildId (number) (Primary key)
ChildName (varchar)
ParentId (number)
i need query for searching all the child elements for a parentid. 1 childid can be a parent id for two childid.
suppose, i ask genealogy for node 3. it should display all the nodes falls below that.
(Ans. :- 8, 9, 14, 17, 15, 11, 13, 16)
i need result as sql query only. (Don't use cursor, procedure so and so)