SELECT substr(SYS_CONNECT_BY_PATH(name, '>'),2) FROM rinceretbtree t where t.code='62010300500301' START WITH code = '62' CONNECT BY PARENT = PRIOR code;