SELECT Level, DisplayName, regexp_replace(hlink, '#chr(35)#','',1,0) as hlink, Target, ItemId, ParentRef, AccessRights, DisplayOrder FROM #application.schema#.Menus WHERE Obs is NULL AND Level = 2 START WITH ItemId = CONNECT BY PRIOR ItemId = ParentRef ORDER siblings BY DisplayOrder, ParentRef SELECT ItemId, ParentRef, DisplayName FROM #application.schema#.Menus WHERE ParentRef IN ( SELECT ItemId FROM #application.schema#.Menus WHERE CONNECT_BY_ISCYCLE = 1 START WITH ItemId = CONNECT BY NOCYCLE ParentRef = PRIOR ItemId )