SELECT path
FROM (SELECT uuid,
trim(both '>' from
trim(both '-' from SYS_CONNECT_BY_PATH(K . NAME, '-->'))) as path
FROM region K
START WITH K.uuid =
(SELECT uuid
FROM (SELECT uuid, pid
FROM region
START WITH uuid = '610204004'
CONNECT BY uuid = PRIOR pid)
WHERE pid IS NULL)
CONNECT BY PRIOR K.uuid = K.pid)
WHERE uuid = '610204004';
reverse('a-->b-->c')
=>
'c>--b>--a
不能实现;并且如果是汉字乱码
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/450962/viewspace-2709563/ ,如需转载,请注明出处,否则将追究法律责任。