Can anyone help me in solving this :
USING RECURSIVE FUNCTION:
SQL DATABASE
TABLE
COLUMN1(id) Column2(Name) Column3(parentId)
1 a Null
2 b 1
3 c 1
4 d 2
5 e 3
in view there is a text box it allows name and id
1. When I enter 1 it has to display the id i.e 1 name a and parentId i.e Null along with the child information i.e 2,b, and 3,c
2. When I enter 3 or c it has to display the parent info i.e 3,c,1 and the child info i.e. 5,e,3 ................
using Recursive function