How to build a hierarchical query to replace the Oracle "Connect By" or standard SQL "With Recursive"

  • updated
  • Completed
I need to create a hierarchical query to generate a path structure (ie: Root \ Level 1 \ Level 2 \ Level 3...) from a database table that has a parent_id field on each level of the hierarchy. I need to replicate existing Oracle SQL code:

Select RQ_REQ_ID,
sys_connect_by_path(RQ_REQ_NAME,'\') as Req_Path
From REQ
Start With RQ_FATHER_ID = 0
Connect By Prior RQ_REQ_ID = RQ_FATHER_ID
Hello, Ken.

It is not possible to build Oracle hierarchical queries visually. You can only type them by hand.