Application Express Views (5.0.4)

There are a huge amount of background tables and views in Oracle’s APEX, and a lot of them are very useful, but hard to find. Below is an excel spreadsheet of all the views that I’ve gathered from other people, with a brief explanation of their purpose.

I only know these to be accurate up to APEX 5.0.4, as these views may or may not exist in subsequent versions.

APEX 5.0.4 – Views

Edit: Turns out you can also query APEX_DICTIONARY. Thanks to Maxime Tremblay on the APEX World Slack for mentioning this one.

select distinct 
   APEX_VIEW_NAME
from
   APEX_DICTIONARY

And Joel Kallman showing once again that there’s always an easier way:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s