View Single Post
  #8 (permalink)  
Old September 6th, 2004, 08:22 AM
pratapbhat pratapbhat is offline
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ID int identity NOT NULL,
Parent int NULL,
Description varchar(100) NULL


if this is your table in oracle 9i there is a simple way of doing it

SELECT Description
    FROM your_table
    START WITH ID = 3
    CONNECT BY PRIOR PARENT = ID
Reply With Quote