I have a query to see the parent and child hierarchical list of data. On running the below query i got the error ORA-01436
.
SELECT ParentPropertyRSN, CONNECT_BY_ROOT PropertyRSN as PropertyRSN,
LEVEL, SYS_CONNECT_BY_PATH(ParentPropertyRSN, '/') Path
FROM Property
CONNECT BY PRIOR PropertyRSN = ParentPropertyRSN
order by level desc;
So I added NOCYCLE
in the CONNECT BY
clause and got the full list of data with its hierarchical path
Now what I need is a query to get the list of rows that have inaccurate data whih cause ORA-01436
.