APEX: Tree with Checkboxes

The APEX Tree component is based on jsTree which is a jQuery Tree Plugin. However not all functionality is implemented in APEX. Knowing the component on which it is based, we can find the documentation and enhance the Tree in APEX. One of these enhancements is to have checkboxes in the APEX Tree component. In this blogpost I will show you how to change the default folders to checkboxes. I will assume that you already have an APEX Tree on one of your pages, and that this one needs to be ammended to have checkboxes instead of folders.

APEX: Tree Based on Multiple Tables

When you have a table with a hierarchical relation it is very easy to create a Tree component in APEX. Simply write the hierarchical query using START WITH and CONNECT BY and you're good to go. When you have a Master-Detail relation between two tables, and you want to show a Tree component you would have to make up the hierarchy yourself in order to use START WITH and CONNECT BY clause. In this blogpost I will show you how to create the query which you can use to create a Tree component with multiple tables.

Reading the Oracle Documentation the Easy Way

Personally I don't like reading documentation from my computer, I prefer to have a "real" book. So when Oracle 12c came out I wanted to read the New Features guide and the Concepts guide again, but the fact that I would have to read it off my computer screen stopped me from really reading it... Skimming the topics was as best as it got.
Of course I could download the PDF's and read it off my e-reader, but I never got around to that.
Yesterday Jeroen Evers told me an easier way (and thus getting rid of all my lame excuses) to read the documentation. The tip was hiding in plain sight, but I never noticed it.
Navigate to the Oracle Documentation Library (link at the bottom of this post) and choose the guide that you want to read, but choose the HTML version of it.
On the top of the page on the right-hand side there are several options, like PDF, Mobi and epub.

From my iPad I chose epub and the guide will be placed in iBooks, making it a lot easier to read:

Links

All the Oracle Documentation
Oracle 12c Documentation Library