Subversion Repositories DevTools

SELECT rel.*,
           LEVEL AS HIERARCHY
  FROM (
  
                SELECT rt.RTAG_ID, 
                       rt.RTAG_NAME, 
                           rt.DISPLAY_ORDER,
                       DECODE( rt.PARENT_RTAG_ID, 
                                           rt.RTAG_ID, 0, rt.PARENT_RTAG_ID ) AS PARENT_RTAG_ID,
                           rt.OFFICIAL,
                           rt.DESCRIPTION,
                           rt.ASSOC_MASS_REF,
               rt.created_stamp,
               uc.full_name as creator
                 FROM RELEASE_TAGS rt, USERS uc
                 WHERE rt.PROJ_ID = :PROJ_ID  
         AND rt.creator_id = uc.user_id (+)
         
                ) rel
START WITH rel.PARENT_RTAG_ID = 0
CONNECT BY PRIOR rel.RTAG_ID = rel.PARENT_RTAG_ID   
ORDER SIBLINGS BY rel.DISPLAY_ORDER