Contribute from: Tim Hartman (TX3)

DB TYPE:           ORACLE 11g

Query:

SELECT
rq_req_id AS "ID",
SYS_CONNECT_BY_PATH (rq_req_name, ' / ') "REQPATH",
tpr_name AS "Type",
rq_req_comment AS "Description"
FROM req
JOIN req_type ON rq_type_id = tpr_type_id
START WITH rq_father_id = - 1
CONNECT BY PRIOR rq_req_id = rq_father_id
ORDER SIBLINGS BY rq_req_name