How to Show and Hide a Detail Row in Oracle APEX
Sometimes there is too much information to display in a table column or it is not necessary to display it (and the data forces the table too wide).
Modify the PL/SQL with a Decode statement as shown in Screen 1.
The result is show in screen 3. The user can click on "Show Detail" or Hide Detail" to control the display of the information in a separate detail row.