How to get all the parents of a given node from a tree in single row?

[jmodic]

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=1023
    connect by prior parent_node_id=node_id
   )
 );

The assumption here is that each leaf node you are making the report for is at exactly fourth level, ie, it allways has three parent levels.