How will we number the parentid,childid and nextid levels of a hierarchy.I want a step by step solution.
For Eg
NODEID INFOOBJECT NODENAME LINK PARENTID CHILDID NEXTID DATETO DATEFROM LANGU TXTSH TXTMD TXTLG
1 0HIER_NODE WORLD 0 2 0 20091231 20090101 D WORLD
2 0HIER_NODE ASIA 1 3 10 20091231 20090101 D ASIA
3 0HIER_NODE INDIA 2 4 6 20091231 20090101 D INDIA
4 0PLANT 1234 3 0 5 20091231 20090101 D
5 0PLANT 1235 3 0 0 20091231 20090101 D
6 0HIER_NODE CHINA 2 7 0 20091231 20090101 D CHINA
7 0PLANT 2393 6 0 8 20091231 20090101 D
8 0PLANT 2394 6 0 9 20091231 20090101 D
9 0PLANT 2395 6 0 0 20091231 20090101 D
World
Asia
India
1234
1235
China
2393
2394
2395