with t as (
select 'xx\yyyy\zzzz' s
  from dual
)   select regexp_substr(s,'[^\]+',1,level)
      from t
connect by regexp_substr(s,'[^\]+',1,level) is not null;