Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







APEX with JavaScript cascading multi-level menus

Oracle Tips by Burleson Consulting

You can extend the basic functionality of APEX menus by adding a JavaScript to allow the menus to "open" and cascade into lower-level menus:


The JavaScript remembers the relative position within the menu and performs super-fast screen refresh capabilities to APEX, removing the need for an expensive screen refresh.

Upon selection, the menu item is also highlighted, providing are pleasant and accurate end-user experience:


MList – Multi-Level Navigation List

The Multi-Level Navigation List (MList) provides a way to have an HTML list display multiple levels similar to a tree list.  The difference is only the lowest level node will provide navigation to another page.  The image to the right shows the MList can support multiple levels of drill-down.

Functional Design

The DDL to create the table holding the definition of the MList is shown here.  The PL/SQL will be at the end of the document.


CREATE TABLE multi_level_list(
   list              VARCHAR(30),
   sequence          INTEGER,
   parent_sequence   INTEGER,
   list_entry_label  VARCHAR(50),
   target_page_id    INTEGER,
   set_these_items   VARCHAR2(100),
   with_these_values VARCHAR2(100) )
ALTER TABLE multi_level_list
ADD CONSTRAINT pkmulti_level_list
   PRIMARY KEY (list, sequence)


LIST – Each list, such as the one shown in the image above, must have a name.  The list above has a name of ‘STAFF’.

SEQUENCE – This is the unique identifier of each item in the LIST.

PARENT_SEQUENCE – When there is a child list item, such as ‘New Staff’, this will contain the value of the SEQUENCE which this item should be displayed below.  If the record is for a top level item this value will be NULL.

LIST_ENTRY_LABEL – The value to be displayed in the list, such as ‘New Staff’.

TARGET_PAGE_ID – What page to navigate to when the list item is clicked.

SET_THESE_ITEMS* – This is a page item on the page you are navigating to (identified by TARGET_PAGE_ID) for which to set a value.

WITH_THESE_VALUES* – This is the value you want to set the page item to (identified by SET_THESE_ITEMS)

* For now you can only set one item using the SET_THESE_ITEMS and WITH_THESE_VALUES columns.  If necessary we can change this in the future.

For more information on this topic, see the book "Easy Oracle HTML-DB Application Express ", the best book anywhere on expert APEX development:

Easy Oracle HTML-DB Application Express
By Michael Cunningham & Kent Crotty

Only $27.95

Buy it now and get the code depot download




Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational