Hi jmodic,

Your query is working fine for one leaf node, but if I give more than one leaf node in the query, its loading parents information of only one leaf.

I have tried as follows...

Code:
 
SELECT MAX(node_company),
       MAX(node_state),
       MAX(node_region),
       MAX(node_district)
FROM
 (SELECT DECODE(node_level,1,node_name) node_company,
         DECODE(node_level,2,node_name) node_state,
         DECODE(node_level,3,node_name) node_region,
         DECODE(node_level,4,node_name) node_district
  FROM
   (select node_id,node_name,node_level,parent_node_id
    from tree
    start with node_id in (1023,1080,1040) 
    connect by prior parent_node_id=node_id
   )
 );

How we can achive it for multiple leaf nodes ?

Thanks in advance

Regards,
Srinivas Medukonduru