I am querying table O_INDEXES to get the mapping of relational_id field. In the SQL display(output) I need to convert relational_id with the corresponding "caption" of each segment.
For example an entry under relational_id field (Eg. 1-400168-400564-400197) should be displayed like : Top-My Service-Child Service-Grand Child Service.
I tried with several self-join queries but eventually fails. Did anyone try it before? Any leads/helps will be appreciated.