Search for a command to run...
Extremely useful!
Oracle APEX already includes Font APEX as the default icon library for Universal Theme. In most cases, that is enough. But in one of my APEX apps, I needed a few icons that were not available there, s
Looking to give your Oracle APEX mobile app a modern, native feel? Here’s a quick hack: add a floating action button that stays anchored at the bottom corner just like in popular mobile apps. This sma
APEX 26.1 has been updated to the Universal Theme. While much of the attention in this release is on AI features, I think the UT improvements are just as important for developers like me who care abou
The apex_barcode package offers a PL/SQL API to generate various types of barcodes. You can output barcodes as SVG (Scalable Vector Graphics) values or as PNG file blobs, making it easy to embed them
Oracle APEX makes it easy to get data on screen fast, but often, the default tabular output isn’t enough. What if you want to highlight statuses, add icons, or display badges all without writing compl
Dictionary views in APEX are similar to dictionary views in Oracle Database. They provide a way to access metadata about the application without having to query the underlying tables directly. Dictionary views are read-only views that can be used by developers, administrators, and other users to gather information about the application.
There are several types of dictionary views in APEX, including:
APEX_APPLICATION_PAGE_REGIONS: Ccontains information about the regions on a page. It includes details about the region type, region name, and region position.
APEX_APPLICATION_PAGES: Contains information about the pages in an application. It includes details about the page name, page ID, and page type.
APEX_APPLICATION_ITEMS: Contains information about the items on a page. It includes details about the item type, item name, and item position.
APEX_APPLICATION_LOVS: Contains information about the list of values (LOV) used in an application. It includes details about the LOV name, LOV type, and LOV source.
APEX_APPLICATION_TABS: Contains information about the tabs used in an application. It includes details about the tab name, tab position, and tab set ID.
To get a list of all available views we can perform the query below.
select *
from apex_dictionary
where column_id = 0;
The example below shows all pages without no page access protection in the app 100 and workspace MY_WORKSPACE.
select *
from APEX_APPLICATION_PAGES
where page_access_protection = 'Unrestricted'
and application_id = 100
and workspace = 'MY_WORKSPACE';
The query below will return a nice view of the dictionary views grouped by hierarchy
select LPAD (' ', (LEVEL - 1) * 2) || apex_view_name s, comments
from (
select 'ROOT' as apex_view_name, null as comments, null as parent_view
from dual
UNION
select apex_view_name, comments, nvl(parent_view,'ROOT') as parent_view
from apex_dictionary
where column_id = 0
)
connect by prior apex_view_name = parent_view
start with parent_view is null
order SIBLINGS by apex_view_name DESC;
In Addition, inside the APEX builder utilities, there is an interactive report listing all the views and a tree view showing the dictionary views like the query above
In conclusion, Oracle APEX dictionary views provide a way to access metadata about the application without having to query the underlying tables directly. Developers can quickly gather information about the application's structure, saving time and effort.