(Complete Developer Reference with Sample Queries)

Oracle APEX stores everything as metadata.

Every page, region, item, process, automation, REST source, workflow, theme — all of it lives inside database views.

These views start with:

APEX_*

Understanding them makes you:

• 🔥 Advanced APEX Developer
• 🔎 Metadata Auditor
• 📊 Governance Engineer
• 🚀 DevOps Automation Builder

🏗 1️⃣ Workspace & Instance Views

These operate at the workspace level.

🔹 APEX_WORKSPACES

Available Oracle APEX workspaces.

SELECT *
FROM apex_workspaces;

🔹 APEX_WORKSPACE_APEX_USERS

Workspace users.

SELECT *
FROM apex_workspace_apex_users

🔹 APEX_WORKSPACE_SESSIONS

Active APEX sessions.

SELECT *
FROM apex_workspace_sessions;

🔹 APEX_WORKSPACE_ACTIVITY_LOG

Page view activity.

SELECT *
FROM apex_workspace_activity_log
WHERE view_date > SYSDATE - 1;

📦 2️⃣ Application Core Views

🔹 APEX_APPLICATIONS

Applications in workspace.

SELECT *
FROM apex_applications;

🔹 APEX_APPLICATION_GROUPS

Application Groups.

SELECT group_name,
       workspace
FROM apex_application_groups;

🔹 APEX_APPLICATION_SETTINGS

SELECT *
FROM apex_application_settings

🔹 APEX_APPLICATION_STATIC_FILES

SELECT file_name,
       mime_type
FROM apex_application_static_files
WHERE application_id = :APP_ID;

🔐 3️⃣ Authentication & Authorization

🔹 APEX_APPLICATION_AUTH

SELECT authentication_scheme_name,
       scheme_type
FROM apex_application_auth
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_AUTHORIZATION

SELECT authorization_scheme_name,
       scheme_type
FROM apex_application_authorization
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_ALL_AUTH

SELECT *
FROM apex_application_all_auth;

📄 4️⃣ Page Metadata Views

🔹 APEX_APPLICATION_PAGES

SELECT page_id,
       page_name,
       page_mode
FROM apex_application_pages
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_PAGE_REGIONS

SELECT *
FROM apex_application_page_regions
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_PAGE_ITEMS

SELECT *
FROM apex_application_page_items
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_PAGE_PROC

SELECT page_id,
       process_name,
       process_type
FROM apex_application_page_proc
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_PAGE_VAL

SELECT page_id,
       validation_name,
       validation_type
FROM apex_application_page_val
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_PAGE_BRANCHES

SELECT page_id,
       branch_name,
       branch_action
FROM apex_application_page_branches
WHERE application_id = :APP_ID;

⚡ 5️⃣ Dynamic Actions

🔹 APEX_APPLICATION_PAGE_DA

SELECT page_id,
       dynamic_action_name
FROM apex_application_page_da
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_PAGE_DA_ACTS

SELECT dynamic_action_name,
       action_name
FROM apex_application_page_da_acts
WHERE application_id = :APP_ID;

📊 6️⃣ Reports & Interactive Grid

🔹 APEX_APPLICATION_PAGE_IR

SELECT page_id,
       region_name
FROM apex_application_page_ir
WHERE application_id = :APP_ID;

🔹 APEX_APPL_PAGE_IGS

SELECT page_id,
       region_name
FROM apex_appl_page_igs
WHERE application_id = :APP_ID;

🔹 APEX_APPL_PAGE_IG_COLUMNS

SELECT *
FROM apex_appl_page_ig_columns
WHERE application_id = :APP_ID;

📋 7️⃣ LOVs & Lists

🔹 APEX_APPLICATION_LOVS

SELECT list_of_values_name,
       lov_type
FROM apex_application_lovs
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_LOV_ENTRIES

SELECT *
FROM apex_application_lov_entries
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_LISTS

SELECT list_name
FROM apex_application_lists
WHERE application_id = :APP_ID;

🎨 8️⃣ Themes & Templates

🔹 APEX_APPLICATION_THEMES

SELECT theme_id,
       theme_name
FROM apex_application_themes
WHERE application_id = :APP_ID;

🔹 APEX_APPLICATION_TEMPLATES

SELECT template_name,
template_type
FROM apex_application_templates
WHERE application_id = :APP_ID;

🔌 9️⃣ REST & Web Sources

🔹 APEX_APPL_WEB_SRC_MODULES

SELECT *
FROM apex_appl_web_src_modules
WHERE application_id = :APP_ID;

🔹 APEX_REST_RESOURCE_MODULES

SELECT *
FROM apex_rest_resource_modules;

🤖 🔟 AI & RAG Views (Latest APEX Versions)

🔹 APEX_APPL_AI_CONFIGS

SELECT *
FROM apex_appl_ai_configs
WHERE application_id = :APP_ID;

🔹 APEX_APPL_AI_CONFIG_RAG_SRCS

SELECT *
FROM apex_appl_ai_config_rag_srcs
WHERE application_id = :APP_ID;

🔄 1️⃣1️⃣ Automations

🔹 APEX_APPL_AUTOMATIONS

SELECT *
FROM apex_appl_automations
WHERE application_id = :APP_ID;

🔹 APEX_AUTOMATION_LOG

SELECT *
FROM apex_automation_log;

🔁 1️⃣2️⃣ Workflows & Tasks

🔹 APEX_APPL_WORKFLOWS

SELECT *
FROM apex_appl_workflows
WHERE application_id = :APP_ID;

🔹 APEX_TASKS

SELECT *
FROM apex_tasks
WHERE application_id = :APP_ID;

🧪 1️⃣3️⃣ Data Generator Views

🔹 APEX_DG_BLUEPRINTS

SELECT *
FROM apex_dg_blueprints;

🔹 APEX_DG_BUILTIN_PERSONS

SELECT first_name,
       last_name
FROM apex_dg_builtin_persons
FETCH FIRST 10 ROWS ONLY;

🐞 1️⃣4️⃣ Issue Tracking System

🔹 APEX_ISSUES

SELECT *
FROM apex_issues;

🔹 APEX_ISSUE_COMMENTS

SELECT *
FROM apex_issue_comments;

🧠 Pattern to Query Any APEX View

Most views follow this filter structure:

WHERE application_id = :APP_ID

Or

WHERE WORKSPACE_NAME = :WORKSPACE_NAME;

🔎 How to Explore More APEX Metadata Views

If you want to explore all available Oracle APEX metadata views directly from the UI, follow these steps:

📍 Navigation Path

App Builder => Workspace Utilities => APEX Views

💡 Pro Tip (Advanced Developers)

You can also query metadata dictionary directly:

SELECT view_name
FROM all_views
WHERE view_name LIKE 'APEX_%'
ORDER BY view_name;

From there you can:

• 🔍 Search any APEX_* view
• 📖 Read view descriptions
• 🧾 See column definitions
• 🗂 Understand relationships between views
• 🧠 Discover newly added views in latest APEX versions

🚀 Why This Matters

With these metadata views you can:

• Generate full application documentation
• Audit security
• Compare Dev vs Prod
• Build governance dashboards
• Detect unused components
• Analyze database dependencies

🏁 Final Thoughts

Oracle APEX metadata is not just system data —

It is a complete development intelligence layer.

If you master these views, you unlock:

✔ Automation

✔ Governance

✔ DevOps

✔ Security Auditing

✔ AI-based App Analysis

Happy APEXING!