The Oracle APEX Guide Oracle Apex Guide RSS Feed
*
Accessibility

Background

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).

Using Javascript the information can be shown or hidden as required.

Modify the PL/SQL with a Decode statement as shown in Screen 1.

Add the Javascript code to the page header as shown in Screen 2.

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.

*

Oracle Apex Row Detail Sql Decode Statement
Screen 1
Page Top
*

Oracle Apex Row Detail Javascript in Page Header
Screen 2
Page Top
*

Oracle Apex Row Detail Display
Screen 3
Page Top

  *  
© RuleWorks - All Rights Reserved - Policy - - Sitemap