select * from (
    select level,
    replace(sys_connect_by_path(decode(level,4,val),'/'), '/')||', '||
    replace(sys_connect_by_path(decode(level,3,val),'/'), '/')||', '||
    replace(sys_connect_by_path(decode(level,2,val),'/'), '/')||', '||
    replace(sys_connect_by_path(decode(level,1,val),'/'), '/')
    from (
            select 0 ID,null PARENT_ID, 'Россия' VAL,'COUNTRY' TYPE_ from dual
            union
            select 1,0, 'Тюменская обл','REGION' from dual
            union
            select 2,1, 'Сургут','CITY' from dual
            union
            select 3,2, 'Ленина','STREET' from dual
            union
            select 4,0, 'Приморский край','REGION' from dual
            union
            select 5,4, 'Владивосток','CITY' from dual
            union
            select 6,5, 'Ленина','STREET' from dual) t     
        connect by prior parent_id = id   
        start with ID = 6
        order by level desc
)
where rownum = 1