# Oracle APEX Consolidated Help

I recently had the need to show "most" of the application help on a single page in my APEX application. In order to make the procedure generic and easy to use, I didn't want to create any additional database objects--just a procedure to output what I needed. I decided to create a separate APEX Navigation List to create the hierarchy of pages that I want to include in the consolidated help page. The easiest way was to copy my "Desktop Navigation Menu" and then modify it. Of course, I could have just used "Desktop Navigation Menu" if it met my needs. The result looks like this  
  

[![](https://cdn.hashnode.com/res/hashnode/image/upload/v1669915122059/xZltP8L8aA.png)](https://3.bp.blogspot.com/-ROWk_72F16U/XGMFzvUcDeI/AAAAAAAABfU/22kTeHofh0oHX38OZ9zxD9l4VATFM2s0QCLcBGAs/s1600/Screen%2BShot%2B2019-02-12%2Bat%2B12.42.37%2BPM.png)

  
  
  
  
Others may need to do the same thing so I'm providing the code here. I apologize that I don't have good code formatting on this blog. I'm providing it as a standalone procedure, but you should put it in a package.  
  
[https://github.com/ainielse/rando/blob/master/output\_consolidated\_help.sql](https://github.com/ainielse/rando/blob/master/output_consolidated_help.sql)