Search code examples
oracle-databaseoracle-apex

Finding Apex Application Tables

I want to get a list of all the navigation menu used in my Apex Application using SQL query.

For example, I could get my Application pages when used this query

select select * from apex_application_pages where application_id =25459;

I would like to get all my navigation menu lists anyone can help me?

Solution

  • Use this sql query select * from APEX_APPLICATION_LIST_ENTRIES where APPLICATION_ID = :APP_ID AND LIST_NAME = 'Navigation Menu'