 
 SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy   START WITH tid=82796159  CONNECT BY PRIOR parent_tid=tid ;
 
-SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy   START WITH 
-tid in (select tid from hierarchical_taxonomy where term like 'Latia%')  
+SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy   START WITH
+tid in (select tid from hierarchical_taxonomy where term like 'Latia%')
 CONNECT BY PRIOR tid=parent_tid ;
 
-SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy   START WITH 
-tid in (select tid from hierarchical_taxonomy where term like 'Latia%')  
+SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy   START WITH
+tid in (select tid from hierarchical_taxonomy where term like 'Latia%')
 CONNECT BY PRIOR parent_tid=tid ;
 
-SELECT TID,PARENT_TID,TERM ,SYS_CONNECT_BY_PATH(term, '/')    FROM hierarchical_taxonomy   START WITH 
+SELECT TID,PARENT_TID,TERM ,SYS_CONNECT_BY_PATH(term, '/')    FROM hierarchical_taxonomy   START WITH
  term like 'Latia%'
 CONNECT BY PRIOR tid=parent_tid ;
 
-SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy where term like 'Latia%'  
+SELECT TID,PARENT_TID,TERM term   FROM hierarchical_taxonomy where term like 'Latia%'
 CONNECT BY PRIOR tid=parent_tid ;
 
-SELECT  LPAD(' ', 2 * LEVEL - 1) || term   FROM hierarchical_taxonomy  
+SELECT  LPAD(' ', 2 * LEVEL - 1) || term   FROM hierarchical_taxonomy
 where term like 'Latia%' START WITH parent_tid is null  CONNECT BY root tid = parent_tid;
 
 nocycle

		      }
		    }
		  });
		}





SELECT  LPAD(' ', 2 * LEVEL - 1) || term ,
SYS_CONNECT_BY_PATH(term, '/')  FROM hierarchical_taxonomy
 START WITH parent_tid is null  CONNECT BY PRIOR tid = parent_tid;

SELECT  LPAD(' ', 2 * LEVEL - 1) || term   FROM hierarchical_taxonomy   START WITH tid in ( select tid from hierarchical_taxonomy where term like 'Latia%') CONNECT BY PRIOR tid = parent_tid;
