Did you try the connect by prior query ?
https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm