Hi All,
I have a hierarchical query that returns the path as /AAA/BBB/CCC where the level of the node CCC is 3.
Would like to get the o/p as '/AAA/BBB' as the parent path for node CCC using regexp_subtr. Please help!
This can be achieved through substr as follows.. but looking for regexp_substr solution
SELECT SUBSTR ('AAA/BBB/CCC', 1, LENGTH ('AAA/BBB/CCC') - 4) FROM DUAL;