Need help on sys_connect_by_path
Posted on 2008-11-15
I am using sys_connect_by_path function.
the field from which information is fetched contains special character which sys_connect_by_path doesnt support.
and because of which sql is erroring out,
Could you please help as to how to remove the special character for sys_connect_by_path funct,,
Below is the sql m using.. Please help
select distinct rtrim(reverse
(FIELD NAME), ' > ')), ' > ') path
from TABLE NAME
connect by prior