select case when connect_by_isleaf =  1  then  0  when level =  1  then  1  else - 1  end as status, 
       level, 
       item_name as title, 
       case when connect_by_isleaf =  1  then 'no_icon.png' else null end as icon, 
       item_id as value, 
       null as tooltip, 
       case when connect_by_isleaf =  1  then  'f?p=&APP_ID.:&P5001_RETURN_PAGE.:&SESSION.:&REQUEST.:&DEBUG.::&P5001_ITEM_NAME.:'||case when :P5001_ITEM_NAME is not null then to_char(dpr.dpr_id) else '' end
       else null end as link 
from table
start with parent_id is null
connect by prior item_id = parent_id
order siblings by item_created

case when connect_by_isleaf =  1  then 'no_icon.png' else 'icon.png' end as icon,