Oracle Query

This is a treeview

Root

• Cricket1 ---Cricket2 ---sachin
  --Cricket3
  --dravid

Id   type  	name
100  Root  	Root
101  cricket	Cricket1
102  cricket	Cricket2
103  player	sachin
104  cricket	Cricket3
105  player	dravid
106  football	FootBALL1
107  player	pele

To maintain the parent-child relationship i have the following relation table

id ParentId

100		null
101		100
102		101
103		102
104		100
105		104
106		100
107		106

I need to query the db and the get the following result

Root

• Cricket1 ---Cricket2

--Cricket3
        

--FootBALL1

        --pele

means when ever it encounters the type of cricket it should not get the childs inside it(as in Cricket3) however if it encounters a child of type cricket , it should go ahead and get the child (as in Cricket1)

Its oracle db , so start with connect by clause can be used

Thanks in Advance

sajid Received on Mon Dec 08 2003 - 06:38:08 CET