select o.* from T_COL o where CONNECT_BY_ISLEAF =1 start with o.COL_ID = xxx connect by prior o.COL_ID =o.PARENT_ID