select *
from
(
  select DIRECTORY_ID as ID, VALUE, DESCRIPTION, reverse(sys_connect_by_path(reverse(MNEMONIC),'/')) as PATH
  from DIRECTORY
  connect by DIRECTORY_ID = prior PARENT_ID
)
where PATH like 'configuration/tarifficators/radius/type_detect/type1/attr1/'

with D as
(
  select DIRECTORY_ID as ID, VALUE, DESCRIPTION
  , sys_connect_by_path(MNEMONIC,'/') as PATH
  from DIRECTORY
  connect by PARENT_ID = prior DIRECTORY_ID
  start with PARENT_ID is null
)
select *
from D
where PATH like '/configuration/tarifficators/radius/type_detect/type1/attr1'