get view of tree using select. oracle 11g

treeview.sql

-------------------  HIERARCHYID => MERCID ---------------------------
select lpad('  ', 6 * level) || h.displayname as Tree,
       hd.value mercid,
       h.hierarchyid,
       h.authid,
       h.searchkey,
       ad.dataid
  from AUTHHIERARCHY h 
    left join hierarchydata hd
    on hd.hierarchyid = h.hierarchyid
   and hd.key = 'mercid'
  left join authdata ad on ad.authid = h.authid
 start with h.parentid = 0
connect by prior h.hierarchyid = h.parentid
-------------------------------------------------------------------------